Total the number of "checked" boxes in a report

[MPH03]

HI !! I am trying to total the number of yes checked boxes on my report in the footer, only want to total the number of checked...do not want total not checked....my current expression is:
=Sum([field name])....but it is not caluclating correctly...can I do what I want to do with check boxes... thanks !!!!

 

[pdldavis]

Hi, One way to do that is to create a text box next to your checkbox and name it something like txtTotals. Set it to invisible and running sum properties to Over All or Over Group as is warranted. Its control source:
=iif(YourCkBxName = -1,1,0)

Place one more text box in the report footer. Its control source: =txtTotals. Running sum set to no.

That should do it.

 

[MPH03]

Thanks !! that took care of it !!! appreciated it !

 

[dhookom]

Use
=Abs(Sum([field name]))
This will not work in a Page Footer, only group and report footers.

Duane
MS Access MVP