Counting occurrencies in a report

[Sato]

Hi,

I'm having dificulties in finding how to count the number of occurrencies in a certain field.
I have a field (checkbox Yes/No) and I want in my report to count the nuber of records that have a "Yes" state.

What's the best way to make it?

ex. I have 10 records, 4 Yes and 6 No.
I want that in the report footer i have the total of "Yes" (in the example it would be 6).
Can you help me?

Thanks

Sato

 

[Rich]

=Sum(Abs([YourField]))

 

[Sato]

Thanks Rich,

You've made it so simple!!!

Sato