Hi All,
I'm haveing real problems using DCount in a text box on a form to count nulls in tblAssigned. I need to count the nulls in the End_Date field. A null means that a contract is rolling and therefore no end date. The expression I'm using is:
=DCount("[ContractorID]","[tblAssigned]",IsNull([End_Date]))
What is wrong with my expression? My other DCounts all work.
The Dcount is returning the number of records in tblAssigned. Any help would be much appreciated.
Thank you in advance,
Cashe
I'm haveing real problems using DCount in a text box on a form to count nulls in tblAssigned. I need to count the nulls in the End_Date field. A null means that a contract is rolling and therefore no end date. The expression I'm using is:
=DCount("[ContractorID]","[tblAssigned]",IsNull([End_Date]))
What is wrong with my expression? My other DCounts all work.
The Dcount is returning the number of records in tblAssigned. Any help would be much appreciated.
Thank you in advance,
Cashe