ignoring empty fields in Count?

  • Thread starter Thread starter Larry Dietrick
  • Start date Start date
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.
 
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.
 
Back
Top