Using "Count" in Queries

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I'm having trouble with a query I'm working on. I am running it with multiple
criteria and it works perfectly fine. However, when I change the "Total" row
from "Group by" to "Count" the query comes up blank. The only time the query
performs as it should, with the counts, is when I delete the criteria for all
the other fields. How can I get the count to work while still keeping the
specific criteria the same?

Thank you in advance for the help!
 
I'm having trouble with a query I'm working on. I am running it with multiple
criteria and it works perfectly fine. However, when I change the "Total" row
from "Group by" to "Count" the query comes up blank. The only time the query
performs as it should, with the counts, is when I delete the criteria for all
the other fields. How can I get the count to work while still keeping the
specific criteria the same?

Thank you in advance for the help!
Click to expand...

Correct the error in the query.

If you would like help doing so please open it in SQL view and post the SQL
text here. Can't fix what we can't see!

I'm going to GUESS that you may want to use the "Where" operator on the totals
line on the fields you're using for criteria; if you also want to group by or
count them, you may need to include the field twice. But not knowing anything
about the table, the query, or the data it's hard to say for sure.
 
Back
Top