DCount Syntax

  • Thread starter Thread starter DS
  • Start date Start date
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)
 
Me.TxtVoids = Nz(DCount("CDCheckID", "tblVoidDetails", "CDBizDay BETWEEN #" &
Forms!frmReportDates!TxtStart & "# AND #" & Forms!frmReportDates!TxtEnd & "#
And CDVoidMan = " & Me.EmployeeID), 0)
 
Back
Top