Thanks for the above, I have tried and failed to incorporate it properly. Below is the SQL for one of my queries to see if it helps figure out where to put this. I use AlphaSplit as the field for the AM and NZ. EmployeeID is the unique field between the EmployeeInfo table which links to the SchedulerClinics table, and from there the Clinic field links the SchedulerClinics table to the Scheduler_Sheet table which is where the bulk of the data for the reports is stored.
Code:
SELECT Scheduler_Sheet.ConsultID, Scheduler_Sheet.LastName, Scheduler_Sheet.FirstName, Scheduler_Sheet.SSN, Scheduler_Sheet.Urgency, Scheduler_Sheet.Program, Scheduler_Sheet.Clinic, Scheduler_Sheet.LastAction, Scheduler_Sheet.DateofAction, Scheduler_Sheet.AppointmentDate, Scheduler_Sheet.RNComment, Scheduler_Sheet.SchedulerComment, Scheduler_Sheet.RNActionNeeded, Scheduler_Sheet.DateOfConsult, Scheduler_Sheet.ConsultNumber
FROM Scheduler_Sheet INNER JOIN (tblEmployeeFiles INNER JOIN tblSchedulerClinics ON tblEmployeeFiles.EmployeeID = tblSchedulerClinics.EmployeeID) ON Scheduler_Sheet.Clinic = tblSchedulerClinics.Clinic
WHERE (((Scheduler_Sheet.Program)<>"Choice") And ((Scheduler_Sheet.DateOfConsult)<Date()-60 And (Scheduler_Sheet.DateOfConsult)>Date()-80) And ((Scheduler_Sheet.Complete)=False) And ((Scheduler_Sheet.DC)=False) And ((tblEmployeeFiles.EmployeeID)=Forms!frmLogin!cboUser)) Or (((Scheduler_Sheet.Program)<>"Choice") And ((Scheduler_Sheet.DateOfConsult)<=Date()-80) And ((Scheduler_Sheet.Complete)=False) And ((Scheduler_Sheet.DC)=False) And ((tblEmployeeFiles.EmployeeID)=Forms!frmLogin!cboUser));
Reformatted the SQL (orange) for readability
Code:
SELECT Scheduler_Sheet.ConsultID
,Scheduler_Sheet.LastName
,Scheduler_Sheet.FirstName
,Scheduler_Sheet.SSN
,Scheduler_Sheet.Urgency
,Scheduler_Sheet.Program
,Scheduler_Sheet.Clinic
,Scheduler_Sheet.LastAction
,Scheduler_Sheet.DateofAction
,Scheduler_Sheet.AppointmentDate
,Scheduler_Sheet.RNComment
,Scheduler_Sheet.SchedulerComment
,Scheduler_Sheet.RNActionNeeded
,Scheduler_Sheet.DateOfConsult
,Scheduler_Sheet.ConsultNumber
FROM Scheduler_Sheet
INNER JOIN (
tblEmployeeFiles INNER JOIN tblSchedulerClinics ON tblEmployeeFiles.EmployeeID = tblSchedulerClinics.EmployeeID
) ON Scheduler_Sheet.Clinic = tblSchedulerClinics.Clinic
WHERE (
((Scheduler_Sheet.Program) <> "Choice")
AND (
(Scheduler_Sheet.DateOfConsult) < DATE () - 60
AND (Scheduler_Sheet.DateOfConsult) > DATE () - 80
)
AND ((Scheduler_Sheet.Complete) = False)
AND ((Scheduler_Sheet.DC) = False)
AND ((tblEmployeeFiles.EmployeeID) = Forms ! frmLogin ! cboUser)
)
OR (
((Scheduler_Sheet.Program) <> "Choice")
AND ((Scheduler_Sheet.DateOfConsult) <= DATE () - 80)
AND ((Scheduler_Sheet.Complete) = False)
AND ((Scheduler_Sheet.DC) = False)
AND ((tblEmployeeFiles.EmployeeID) = Forms ! frmLogin ! cboUser)
);