Assistance needed in counting null values

[Voyager]

Hi Team,
I want to get the count of null values of a table to be shown in a text filed of an unbound form. So I am using the below given code in the control source of the field however I am getting an error could you help me out?

=count(iif(isnull(“[tablename]”!”[fieldname]”),true,1,0))

 

[isladogs]

Several mistakes in your code. Use this instead

=DCount("*","TableName","FieldName Is Null")

 

[Voyager]

It works. Thanks for the help Ridders. I’m working on improving my knowledge in vba.

 

[isladogs]

You're welcome