Compound dcount function
Posted on 2012-04-09
I'm trying to use the following code and it bombs out, any suggestions... All I'm trying to do is count the number of records that have a checked box in one column and a null date field in another...Simple right???
Me.fldSA_No_PAA_Date.Value = DCount("[Employee No]", "tblSAARN", "[fldTOA_Privl] = yes" And "IsNull([fldPAA_Date])")
If I try the two conditions individually they both return the proper values but I try and concatenate them into the same dCount function it freaks out????