using a query to run a report that only selects one answer

[Guest]

I am attempting to write a query on input values that can be Yes, No or N/A
but on the query I only want a count by category of the No responses. I am
having no luck so far using either count or dcount.

 

[Marshall Barton]

I am attempting to write a query on input values that can be Yes, No or N/A
but on the query I only want a count by category of the No responses. I am
having no luck so far using either count or dcount.

Sum(IIf(somefield="No", 1, 0))