SQL Count

  • Thread starter Thread starter epoh97 via AccessMonster.com
  • Start date Start date
E

epoh97 via AccessMonster.com

I have a query/report that is trying to select the number of members referals
per member.

How do I display the member name and the number of referals?

CurrMems
John Doe
John Doe
John Doe
Jane Doe
Tarzan Wild
Jane Wild
Jane Wild

Select Count(*)
FROM tblMems
 
Select CurrMems, Count(*) As NumOf
FROM tblMems
GROUP BY CurrMems;

You may need to change field names.
 
Back
Top