Counting "Yes/No" Tick Box Fields and presenting in a report footer

[Jamescdawson]

I have a form with supporting table which has Yes/No tick box fields for Age Ranges... (i.e. a separate tick box for for a each range)

"18-24"
"25-30"
"31-55"
"56-65"
"65+"

I have created a report that lists various details and presents all five tick boxes in columns in the report to show the age group of that record.

I'd like to count the number of ticks in the report for each column and present the number at the bottom of each column in the report footer.

If I use "=Count(FieldName)" it counts both Yes & Nos. (Ticked and Not Ticked) Can anyone help? What am I doing wrong ?

With hindsight, I wish I had created a combo box with a drop down choice, but I feel that there must be an easy solution to this tick box route

Jimbo

[aytee111]

=Sum(IIf([18-24]=True,1,0))

[CJ_London]

or

=abs(sum(([18-24]))

[Jamescdawson]

Thanks aytee11

Works fine now