DCount Syntax

[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)

 

[Dennis]

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

 

[DS]

Thanks
Works great!
DS