I have a query that counts the percent of administrators who have seen patients during a given month selected by a combo box. It doesn't add up to 100% each month though and I can't figure out why. Here is the SQL and a screen shot of the subform.
Code:
SELECT Month([DateofRounding]) AS [Month], [tblNurse Rounding Leader].NRLLastName, [tblNurse Rounding Leader].NRLFirstName, Count(*) AS [Number of Times Rounded], Count(*)/(SELECT Count(*) FROM tblPatient AS [XX] WHERE Month(tblPatient.[DateofRounding]) = [Forms]![frmMain_expandlg]![Subform1]![cboMonthRPT])*1 AS [Percent Total]
FROM [tblNurse Rounding Leader] INNER JOIN tblPatient ON [tblNurse Rounding Leader].[Nurse Rounding LeaderID] = tblPatient.fk_LeaderInitials
WHERE (((Month([DateofRounding]))=[Forms]![frmMain_expandlg]![Subform1]![cboMonthRPT]))
GROUP BY Month([DateofRounding]), [tblNurse Rounding Leader].NRLLastName, [tblNurse Rounding Leader].NRLFirstName;

Thanks!