So I have done things like this, but never this exact scenario and cannot figure out how to design it.
I have a report that is displaying a department, and a list of students who meet X criteria in that department. What I want to do is this:
E-mail the report to the department where students are meeting X criteria. But not the entire report, just the list of students that actually belong to that department.
Right now I have my query built to select the data I need based on the criteria, and I have the report based on the query. But for some reason I cannot wrap my head around where to go from here. Any help?
Just an FYI here is what my selection query looks like
Code:
SELECT DISTINCT Current_Work_Study_Earn.Balance, Stu_Info.Stu_Last, Stu_Info.Stu_First, Stu_Info.Stu_Middle, Stu_Term.Aid_Year, Stu_Assn.Reassign, Dept.Dept_Desc, Dept.Sub_Dept, Stu_Assn.Stuassn_ID, Contacts.Cont_First, Contacts.Cont_Last, Contacts.Cont_Email, Stu_Info.Camp_ID, Stu_Info.Hr_ID, Stu_Info.Stu_Email
FROM (((((Stu_Term INNER JOIN (Current_Work_Study_Earn INNER JOIN Stu_Info ON Current_Work_Study_Earn.[Person ID] = Stu_Info.Hr_ID) ON Stu_Term.Empl_ID = Stu_Info.Empl_ID) INNER JOIN Stu_Assn ON Stu_Term.Stuterm_ID = Stu_Assn.Stuterm_ID) INNER JOIN Local_Vars ON Stu_Term.Aid_Year = Local_Vars.Aid_Year) INNER JOIN Dept_Cont ON (Stu_Assn.DC_ID = Dept_Cont.DC_ID) AND (Local_Vars.Aid_Year = Dept_Cont.Aid_Year)) INNER JOIN Dept ON Dept_Cont.Dept_ID = Dept.Dept_ID) INNER JOIN Contacts ON Dept_Cont.Cont_ID = Contacts.Cont_ID
WHERE (((Current_Work_Study_Earn.Balance)<500) AND ((Stu_Term.Aid_Year)=[Local_Vars].[Aid_Year]) AND ((Stu_Assn.Reassign)=False));