Counting Check Boxes

G

Guest

I have a form that uses a number of check boxes for certain conditions. I
would like to create a query that counts the number of "Yes" answers for each
field.

Please help

Thanks.
 
G

Guest

Yes is stored as -1 and No as 0. Therefore the following will work for
counting up all the yesses in a Totals query..

Yeps1: ABS(Sum(YourYesField1))
 

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

Create a queries with many yes/no check boxes 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Can a query be ran by check boxes in a form? 1
Multi-Value Field Query 0
Query using check box data 7
Combo Boxes 4
Query based on Check boxes 1
Can I display just the fieds that are checked 2

Top