Counting number of checkboxes

[shadowspell]

When generating a report, how can I get a total on the number of times a certain checkbox was checked?
Thanks,
Chris

 

[Fornatian]

If the checkbox is on your report use an expression in the footer of the group suchas:

=Sum(Abs([YourChkBx]))

 

[dcx693]

FYI shadowspell, Fornation's formula works because Access stores the values of checkboxes as true or false. Internally, Access stores true as -1 and false as 0.

 

[shadowspell]

Thx

Thank you Fornation, that did exactly what I needed.
Chris