totals on query

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top