Report Footer Count Function

[tom.hansen]

I am trying to include a count function in a report footer. I would like to count the number of "Yes" answers in a column of Yes/No check boxes. Even when I query the information I end up with counting the number of records instead of counting the Yes answers. Any suggestions?

 

[Rich]

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