DCount - Empty Records

[systemx]

Hi all,

Hoping for a little help. I am trying to DCount all records in a tblMail where field 'Date_Received' is empty/null.

I am using -

Me.txtMOustanding = DCount("*", "tblMail", "[Date_Completed]" = Null)

This seems to count all records in the table, and not those where Date_Completed field is empty.

Can anyone help me with this?

Thanks

Rob

 

[WayneRyan]

systemx,

Me.txtMOustanding = DCount("*", "tblMail", "IsNull([Date_Completed])")

Wayne

 

[systemx]

So obvious. Thanks Wayne!