Count the "Yes's"

[NotSoC#]

I have a query with field called MemberAttend..... This field tells me if a memeber attended a meeting. The only options for this field is 'Yes' , 'No' , 'N/A'.

My question is how 'in a query' can i count the number of Yeses i have.

Any help would be great.................C

 

[Rich]

Either on a form or report.
Sum(Iif([MyField]=Yes),1,0)