Count the Yeses!

[christy]

I have a combo box in which the user can select Yes/No or N/A.(This Cbo is on a subForm)What i want to do is add a text box to the main form and count how many times the Yes has been selected by a user.

I know this will be easy for alot of U out there but i would appreciate so help.

Thanx...........Christy

 

[Pat Hartman]

Add a footer to the subform. In the footer, add a control to count the yes values:

=Sum(IIf(YourField = "Yes",1,0))