How to count "yes" responses on a report...?

[walstib77]

I am wondering if I can solve a report need with VBA code that would count the number of "yes" entries for a given field and post a total at the bottom of the column...?

I have tried to do this using queries, and have run into problems that leave me wondering this question.

 

[smig]

I guess these "yes" are stored in a table. if the do create a query and create a new field:
CountYes:IIf([FieldName] = "yes", 1, 0)

sum the result at the form's bottom header:
sum([CountYes])