Counting Null Values

[Guest]

I am compiling a statistical report that lists the number of clients in
certain categories... but some fields contain no data and DCount ignores
these fields. How can I get a count of how many records contain a Null Value
in a particular field?

 

[Guest]

Try this --
IIF([YourField] Is Null, 1, [YourField])

Put quotes around the one if [YourField] is datatype Text.

 

[Jerry Porter]

This will count the records in the table tblClients where the field
Category is null:

DCount("*","tblClients","Category Is Null")

Jerry

 

[Guest]

Awe... the * is the key! That is what I was missing. Thanks for your help.