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;