Summing a counted field...

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

OK, I have done this query to count the number of "good"
and "excellent" but I want to know the total count
of "good" OR "excellent", and I can only get two rows.
How do I sum the two rows so that I get a total?
 
Create a column in the query grid for your field and
select "Where" from the Total dropdown and with '"good"
or "excellent"' as your criteria. Then create a second
column for the field and select "Count" as your total.
 
Back
Top