DCOUNT - trying to count text fields that contain nothing

[homer2002]

using the DCOUNT function can I count empty text field on a table



i.e.

DCOUNT ([fieldname],"Tablename","[fieldname] is Null")

(where fieldname is a field of type text)


cause i am dumb and I can't get this to work

 

[Rob.Mills]

It can't actually count null fields because there's nothing associated with it. What I usually do is run the dcount on the key of the record with the where clause the same as you have it.

 

[Jon K]

Try this:-

=DCount("*","TableName")-DCount("FieldName","TableName")