DCount and SQL

[DSTR3]

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

[weekend00]

didn't you get it already?

[DSTR3]

No I didn't. This DCount seems different from the other one.
DS

[weekend00]

what is different? doesn't it return the result which want?