Thread: Getting Counts
View Single Post
  #1 (permalink)  
Old October 27th, 2004, 02:35 PM
hugh@kmcnetwork.com hugh@kmcnetwork.com is offline
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default Getting Counts

Hello Everyone and thanks for your help in advance. I am having trouble with a query. I need to return one occurrence of an individual's name and ID number along with the count for the number of times this person appears in the table. I have tried a Group By clause, but to the best of my knowledge, would require the Group By part to have both NAME and ID in the grouping, which doesn't seem to return what I want. I have tried Select Distinct, but can't figure out how to get the count. Any help on this topic would be greatly appreciated. Thanks.

Reply With Quote