Counting rows returned from a query

[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

 

[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

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

for each member. It is a membership database, and