Hello,
Any help would be greatly appreciated. I have a database with the following components.
Table1 - Applicant details, includes a text field for location.
Table2 - List of locations
Queries Source - Table1
Query1-With Human Resources
Query2 -Pending Interview
Query3-Offer Made
Report1 - Recruiter, based off of Query1
Report2 - Interviewer, based off Query2
Report3 - Supervisor, based off Query3
I am trying to put together a code that would filter reports 1,2, and 3 by the same location and export as pdfs to a folder. The folder's name would match the filtered location. I want to loop this action through all 56 locations. I have tried and failed so many different ways I struggle to communicate them to you. Thank you in advance for any ideas you may have. These reports would be run on a bi-weekly or monthly basis.
Any help would be greatly appreciated. I have a database with the following components.
Table1 - Applicant details, includes a text field for location.
Table2 - List of locations
Queries Source - Table1
Query1-With Human Resources
Query2 -Pending Interview
Query3-Offer Made
Report1 - Recruiter, based off of Query1
Report2 - Interviewer, based off Query2
Report3 - Supervisor, based off Query3
I am trying to put together a code that would filter reports 1,2, and 3 by the same location and export as pdfs to a folder. The folder's name would match the filtered location. I want to loop this action through all 56 locations. I have tried and failed so many different ways I struggle to communicate them to you. Thank you in advance for any ideas you may have. These reports would be run on a bi-weekly or monthly basis.