count empty boxes

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
 
M

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
 
J

John Spencer (MVP)

Perhaps, something like:


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