DCount Syntax

D

DS

I'm having a rough time getting this syntax right. EmployeeID is a number
field. Any help is appreciated.
Thanks
DS

Me.TxtVoids = Nz(DCount("CDCheckID", "tblVoidDetails", "CDBizDay BETWEEN
Forms!frmReportDates!TxtStart AND Forms!frmReportDates!TxtEnd And CDVoidMan
= Me.EmployeeID"), 0)
 
D

Dennis

Me.TxtVoids = Nz(DCount("CDCheckID", "tblVoidDetails", "CDBizDay BETWEEN #" &
Forms!frmReportDates!TxtStart & "# AND #" & Forms!frmReportDates!TxtEnd & "#
And CDVoidMan = " & Me.EmployeeID), 0)
 
Top