Calculating totals with checkboxes

A

acomphenn

On my report I'm trying to calculate how many checkboxes are checked off for
a certain category, but I can't figure out what I should put for the
countrolsource. Can someone help me??
 
F

fredg

On my report I'm trying to calculate how many checkboxes are checked off for
a certain category, but I can't figure out what I should put for the
countrolsource. Can someone help me??

Use an unbound control.
=Abs(Sum([CheckBoxName]))
 
A

acomphenn

What do you mean by an unbound control?

fredg said:
On my report I'm trying to calculate how many checkboxes are checked off for
a certain category, but I can't figure out what I should put for the
countrolsource. Can someone help me??

Use an unbound control.
=Abs(Sum([CheckBoxName]))
 
F

fredg

What do you mean by an unbound control?

fredg said:
On my report I'm trying to calculate how many checkboxes are checked off for
a certain category, but I can't figure out what I should put for the
countrolsource. Can someone help me??

Use an unbound control.
=Abs(Sum([CheckBoxName]))

It means the control source of the control is NOT bound to any field
in the table. Also make sure the name of this control is not
"CheckBoxName".
 
Top