Counting Check Boxes

EB · Dec 26, 2003

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

fredg · Dec 26, 2003

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?

To count the number of Yes values:
=ABS(Sum([CheckBoxName]))

To Count No values:
=Sum([CheckBoxName]+1)

EB · Dec 26, 2003

Thank you so much Fred.