How do I count check boxes?

S

springschick

I have a simple database with a check box, set as a Yes/No field. I need to
count the number of checked boxes in my report. I have tried a few different
things, but nothing worked. If someone could help me with this, I would be
most appreciative. Thank you.
 
F

fredg

I have a simple database with a check box, set as a Yes/No field. I need to
count the number of checked boxes in my report. I have tried a few different
things, but nothing worked. If someone could help me with this, I would be
most appreciative. Thank you.
Click to expand...

Using an unbound text control:
=ABS(Sum([CheckBoxFieldName]))
 
S

springschick

Thank you! Worked like a charm!

fredg said:
I have a simple database with a check box, set as a Yes/No field. I need to
count the number of checked boxes in my report. I have tried a few different
things, but nothing worked. If someone could help me with this, I would be
most appreciative. Thank you.
Click to expand...

Using an unbound text control:
=ABS(Sum([CheckBoxFieldName]))
Click to expand...
 

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

Word OLE to check spelling in text box 1
Section and Page numbering 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Link a text box based on drop down box with four options MS Word 365 0
Possible to Combine reports to's to a single box? 0
How to have two tables on same line? 1
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Count Only Yes checks in Access Report 1

Top