Counting Check Boxes

E

EB

I am trying to count the number of "yes" check boxes in a column in an Access Report. How do I do this?
 
F

fredg

EB said:
I am trying to count the number of "yes" check boxes in a column in an
Access Report. How do I do this?
Click to expand...
To count the number of Yes values:
=ABS(Sum([CheckBoxName]))

To Count No values:
=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

Populate a table based on check box status 2
How to count the numbers in a Word document? 0
Word OLE to check spelling in text box 1
Section and Page numbering 0
A03 - count in report footer gives me #Error? 0
Possible to Combine reports to's to a single box? 0
Cannot Put A Border Around Numbered Text. What To Do? 0
Count Only Yes checks in Access Report 1

Top