How do I count check boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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]))
 
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...
 
Back
Top