Using the COUNT function

F

FC

I have a column with entries of "YES" and "NO" I need to prepare a query to
count the no of YES AND NO'S in this column.
Please help!!!!
Thanks
 
F

fredg

I have a column with entries of "YES" and "NO" I need to prepare a query to
count the no of YES AND NO'S in this column.
Please help!!!!
Thanks
Click to expand...

Is it a Check box field Yes/No or a Text datatype field "Yes"/"No"?

Check box field:
=Abs(Sum([CheckBoxName]))

If it is a Text datatype field "Yes" or "No":
=Sum(IIf([FieldName]="Yes",1,0))
 
Top