Summing Checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a yes/no checkbox in one of my reports. At the end of the report I
want to do a Sum for each checkbox that is checked. I can't figure out how
to do this. Is it possible and if so how?
 
I have a yes/no checkbox in one of my reports. At the end of the report I
want to do a Sum for each checkbox that is checked. I can't figure out how
to do this. Is it possible and if so how?
Click to expand...

Because a check box value is either 0 or -1, if you simply add them
you will get a count of the checked ones. Because the value will
always be a negative one, the ABS() function will return the positive
count.

In an unbound text control:
=ABS(Sum([CheckBoxname]))

If it is easier to understand, you can also use:
=Sum([CheckBoxName]) * -1
 
Back
Top