Query grouping Count

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
 
J

Jeff Boyce

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>
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Shift several columns in table 4
How to display zero value in blank fields of Cross Tab query 0
Group By, Max and Min 2
Duplicates in some fields, but not others 0
IIF Function Within A Query 8
Report Group Footer DLookUp 0
Select to reference an other record or row 1

Top