Counting Null Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Try this --
IIF([YourField] Is Null, 1, [YourField])

Put quotes around the one if [YourField] is datatype Text.
 
This will count the records in the table tblClients where the field
Category is null:

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

Jerry
 
Back
Top