Query grouping Count

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a query that is grouped by field1 and then grouped
by field 2 and counts the records in field3. The problem
I have, and I'm sure its a simple one, is how do I get the
query to return results of 0 from the count of field3?
There are two options for field2, A and B, if there are no
B's how do get the query to show that?

Thanks for your help
 
Tom

This sounds a little like a cross-tab query. Have you check out that topic
in Access HELP?

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top