I'm trying to get a query to list results, but combine and count them. Meaning if a result is "Virginia" and it pops up 4 times, it lists "Virginia" once with a count of 4 under it. This is what I'm getting.
State 0000001 Virginia 0000002 Virginia 0000003 Virginia 0000004 COUNT 3
What I would like to get is: State 0000001 Virginia 0000002 COUNT 3
Anyone have any pointers?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.