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

T

TLocker

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.
 
M

Marshall Barton

TLocker said:
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.
Click to expand...

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