Where should I wrote this? In a new text box in the Control Source area? In
the report footer.

"Klatuu" wrote:

=Abs(Me.chkBox1 + Me.chkBox2 + Me.chkBox3 + Me.chkBox4)

Checkboxes that are checked evaluate as True with a value of -1
Checkboxes that are not checked evaluate as False with a value of 0

If 2 and 3 are True and 1 and 4 are False, then adding the values up returns
-2
So, if you use the Abs function, it drops the sign bit and returns 2.

TaDa!

"jeannette_rivera" wrote:

I had a report with a list of services, those services shows as check box
with yes/no value in the table. I would like to count the boxes with value
on it, all the ones marked. If I did the count() it count all of them with
or without info on it. Obviously I'm doing something wrong.

You're the best, so I'm sure you can help me fix this.

Thanks.