Counting true checkboxes

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

Guest

I have a report that currently displays 50 records. Each record includes a
checkbox and 20 of them are currently "true". In my Report Footer, I'd like
to display a tally of the "true" checkboxes. However, if I do a
"=Count([Checkbox])", my result = 50. What do I need to do to tally only the
"true" checkboxes? Thanks.
 
Count counts any Checkbox that has a value and all checkboxes have a value
of True(-1) or False(0). The only thing count does not count is null
values.

You can get the results you want using

=Abs(Sum([CheckBox]))

or

= Count(IIF([CheckBox] = True,1,Null))
 
Back
Top