count empty boxes

[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

 

[Michel Walsh]

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

 

[John Spencer (MVP)]

Perhaps, something like:


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