Counting rows returned from a query

J

John Lawrence

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
 
H

hcj

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
 
Top