Re: count empty boxes

From: Michel Walsh (vanderghast_at_VirusAreFunnierThanSpam)
Date: 04/05/04 

Date: Mon, 5 Apr 2004 06:24:18 -0400

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

"Sabine" <anonymous@discussions.microsoft.com> wrote in message
news:1821201c41ae3$4af6c080$a301280a@phx.gbl...
> 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

Relevant Pages