How do I get the count of yes/no's in a query ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My database collects a lot of Yes/No questions. The query is date specific,
and it asks to find how many ESA tune-up were performed and of those a yes/no
field asks if the customer invested in an ESA renewal. The query shows this
with no problem. The problem I have is how can I show in this query how many
records in the database were queried to get this information.
 
My database collects a lot of Yes/No questions. The query is date specific,
and it asks to find how many ESA tune-up were performed and of those a yes/no
field asks if the customer invested in an ESA renewal. The query shows this
with no problem. The problem I have is how can I show in this query how many
records in the database were queried to get this information.
Click to expand...

You can take advantage of the fact that a check box has a value of
either -1 or 0.

To count Yes's:
CountOfYes:Abs(Sum([CheckBoxName]))

To count No's:
CountOfNo:Sum([CheckBoxName]+1)
 

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

counting yes/no fields 3
Counting up Yes/No fields in queries 3
YES /NO Query 1
Count Yes/No with Criteria 2
Counting records in a query 9
Yes / No query problem 4
query to do counts of yes's in yes/no boxes.. 1
Negative Number when Counting Yes/No 2

Back
Top