yes/no

  • Thread starter Thread starter Paola
  • Start date Start date
P

Paola

how do i count how many yes or no i have in a query? the
info is coming from a table that has a yes/no check box
field.
any info is appreciated
 
Paola,
To count Yes:
CountYes:Abs(Sum([CheckBoxField]))

To Count No:
CountNo:Sum(IIf([CheckBoxField]=0,1,0))
Or..
CountNo:Sum([Check]+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

Access Dcount (multiple criteria) 3
counting yes/no fields 3
Counting up Yes/No fields in queries 3
Countif on qry 6
Yes/No parameter for Yes or No or Both 7
Cleaner way to query for negatives? 3
Update Query 10
Evaluate Yes/No Field Based on User Input 7

Back
Top