totals on query

G

Guest

I have a query that has a yes/no box in it, I want to get a total count just
on the yes. How can I make my query work where it will give me a total number
not just 1's 1's. I've gone to the Totals but I must be doing something wrong
because its not giving me a grand total.
 
G

Guest

Not sure if that what you are looking for, but try this

SELECT TableName.FieldName, Count(TableName.FieldName) AS CountFieldName
FROM TableName
GROUP BY TableName.FieldName
HAVING TableName.FieldName=True
 

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

Top