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.

I apologize if I have not understand you question. Is this you are looking for..?

SELECT ID,Name,Count(Name) As Total
FROM Table
GROUP BY ID,Name

Perfect! Thanks for the help.