I have a DCount statement with a Query. I want to use SQL. How do I do a DCount with SQL?
The statement
Dim EOD As Long
EOD = Nz(DCount("EmpSignedIn", "QueryEOD"), 0)
The SQL
SELECT tblEmployees.EmpSignedIN, tblSecurityDetails.SDPrivID
FROM tblEmployees INNER JOIN (tblJobsEmp INNER JOIN tblSecurityDetails ON tblJobsEmp.JobSecurityID = tblSecurityDetails.SecurityID) ON tblEmployees.EmployeeID = tblJobsEmp.EmployeeID
GROUP BY tblEmployees.EmpSignedIN, tblSecurityDetails.SDPrivID
HAVING (((tblEmployees.EmpSignedIN)=True) AND ((tblSecurityDetails.SDPrivID)=96));
Thanks
DS