Counting records of yes/no fields in a report (1 Viewer)

[Carolyn]

Hello All,

I have a report with 10 fields that are yes/no. When I make a report I want it to count the how many records are yes for each field. Gosh I hope that I am making sense. Lack of sleep and this being my first posting are creating what my daughter calls a brain fart. Thanks for your help and I certainly hope that I have provided enough information.

Carolyn

 

[Graham T]

Carolyn

Should be:

=Sum(IIf([Your Field Name]=Yes,1,0))

Hope this helps

Graham

 

[David R]

=Sum(Iif([MyField]=True,1,0))

in an unbound field in the appropriate footer should work.

 

[Carolyn]

Thank you Gentlemen for your response. It works great!

Carolyn