How do I count check boxes?

G

Guest

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]))
 
G

Guest

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

Counting Multiple Check Boxes 6
Totalling check boxes 5
Count not null check boxes 5
Counting results of "yes" check boxes and combo box selections 2
Count of records where checkbox 1 is unchecked, checkbox 2 is chec 1
Working With Check Boxes 2
Count Only Yes checks in Access Report 1
Please help with Count() 16

Top