yes/no

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
 
F

Fredg

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
Yes/No parameter for Yes or No or Both 7
Countif on qry 6
counting yes/no fields 3
Update Query 10
Counting up Yes/No fields in queries 3
Evaluate Yes/No Field Based on User Input 7
calculating a percentage 1

Top