Good day,
Can someone identify the reason for type mismatch error I'm getting for following code:
If DCount("fldAuditDate", rstNewTable, "Format$(fldAuditDate,'yyyymm')='" & Format$(nxtInspection, "yyyymm") & "'") < intInsp Then
Not sure if it's something obvious or not. I've tried putting #...