Counting rows returned from a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I am trying to count rows returned on a query. The query is on a Yes/No field, and I need to fin
how many people are "Yes
I have tried the group by 'Count', but it only returns 1 for each member. It is a membership database, and
I'm trying to find out how many people have paid their dues

Thank you

John
 
Try leaving the member name field out of the query, as
well as any other fields that don't contrbute to the count.
If you group on anything other than the counted field,
you'll get counts for each group.
Hope this helps.

-----Original Message-----
Hello,

I am trying to count rows returned on a query. The query
Click to expand...
is on a Yes/No field, and I need to find
how many people are "Yes"
I have tried the group by 'Count', but it only returns 1
Click to expand...
for each member. It is a membership database, and
 
Back
Top