[dinodeserter]

This is my first posting on here. I have a form that Nursing leaders can use to select a month from a combo box and see the number of people who have seen patients in a month. Basically I want to change the query to add the total number of each person who rounded and then give a percentage of the total. Here is a copy of my SQL for the query.

SELECT tblPatient.DateofRounding, [tblNurse Rounding Leader].NRLLastName, [tblNurse Rounding Leader].NRLFirstName
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]));

P.S. The names of the forms are strange from the GUI Menu I use.