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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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))
 
Back
Top