M
Marshall Barton
DS said:I have this DCount on a Report Header it pulls the Dates from 2 fields
on a form. I'm getting an #Error....
=Nz(DCount("CheckID","tblChecks","ChkBizDay
You need to use complete comparisons:
=Nz(DCount("CheckID","tblChecks",
"ChkBizDay >= Forms!frmReportDates!TxtStart
AND ChkBizDay <= Forms!frmReportDates!TxtEnd"), 0)
Or use the Between operator:
=Nz(DCount("CheckID","tblChecks",
"ChkBizDay BETWEEN Forms!frmReportDates!TxtStart
AND Forms!frmReportDates!TxtEnd"), 0)