Counting records of yes/no fields in a report

Carolyn

Registered User.
Local time
Today, 04:39
Joined
Jun 14, 2002
Messages
28
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
 
Carolyn

Should be:

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

Hope this helps

Graham
 
Code:
=Sum(Iif([MyField]=True,1,0))
in an unbound field in the appropriate footer should work.
 
Thank you Gentlemen for your response. It works great!

Carolyn
 

Users who are viewing this thread

Back
Top Bottom