count empty boxes

  • Thread starter Thread starter Sabine
  • Start date Start date
S

Sabine

Hello Everyone,

I like to to do a querie in which you can ask for empty
boxes in a category, which means I like to count the boxes
wich are not filled in. I already tried with the criteria
IS NULL or ("") and the function "sum" or "count" but it
doesn't work.
Does anyone know how to do that?
Thanks in advance, have a nice day
Sabine
 
Hi,




SELECT COUNT(*)-COUNT(FieldName)
FROM myTable



would return the number of records having a NULL in the mentioned field
name.


Hoping it may help,
Vanderghast, Access MVP
 
Perhaps, something like:


SELECT Abs(Sum(YourCategoryField Is Null)) as CountNulls
FROM YourTable
 
Back
Top