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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report List with Commas 6
hiding duplicated data in subreport 6
modified pivot table using a macro 2
Countif. 1
Excel Converting rows into each individual reports 0
select only first names 2
need mailing list report to include husband & wife or one or the o 1
Detail Section-Field Spacing 7

Back
Top