Summing a counted field...

[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?

 

[Roy]

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.

 

[Eric]

Nevermind...figured it out...