Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error in count command (2003)

    There appears to be a problem with the Count command in that it is not showing on SR#s records which occur more than once.
    See screenshot for details.
    Attached Images Attached Images

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Error in count command (2003)

    You can't do a GroupBy on the SR# if you want to do a Count on them. If you need to restrict your results to a certain set, then use a Where clause - otherwise take the leftmost column out completely.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •