If I had several text boxes with different names like: New ATM, Loan,
Letter... How can I get sum all the equal ones marked. For example all the
"Loan" Check Box.

sorry but I'm like new in this and really can't get this working.

Jeannette

"Sprinks" wrote:

Hi, Jeannette.

Klatuu's response shows how to total the Yes responses of multiple fields in
a single record. To total the number of Yes values in a single field for an
entire table, the following expression in the Detail or Form footer will
return the value:

=Sum(Abs([YourCheckBox])

Sprinks

"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.