Show Blanks in count as 0

[WickidWe]

In the query below(underlined and bold), how do I return the the count as 0 instead of blank?

SELECT tmp.name, sum(tmp.groupid) AS pick
FROM (SELECT tblEmpDetails.Name, tblFctnGroup.GroupID, tblRosterRec.Date_, Count(tblRosterRec.EmpId) AS CountOfEmpId FROM ((tblFctnGroup INNER JOIN tblFunctions ON tblFctnGroup.FctnGroup = tblFunctions.FctnGroup) INNER JOIN tblRosterRec ON tblFunctions.ReliefCode = tblRosterRec.FctnID) INNER JOIN tblEmpDetails ON tblRosterRec.EmpId = tblEmpDetails.EmpId WHERE (((tblRosterRec.Date_)<=[Forms]![Form1]![txtDate] And (tblRosterRec.Date_)>=[Forms]![Form1]![txtDate2])) GROUP BY tblEmpDetails.Name, tblFctnGroup.GroupID, tblRosterRec.Date_ HAVING (((tblFctnGroup.GroupID)=1))) AS tmp
GROUP BY name;

[June7]

Try:
Nz(Count(tblRosterRec.EmpId),0)

[WickidWe]

That Did It! Thanks