ignoring empty fields in Count?

L

Larry Dietrick

When you set the Totals field of a query to "Count", any
way you can get it to ignore table cells that don't have
anything in them and only count how many actual entries
there are? Thanks.
 
J

jmonty

In query design mode, try adding: <>Null
in the Criteria (row) under the field you are trying to
count.
Note: this will limit your query to only those records
that have a value in that field. So this will not work if
you want all records, but only count those with values.
That would be a little more complicated. In that case I
would look up the "IN" clause under Help.
 
Top