Hi there,
I would like to create an automated weekly schedule for my volunteers business.
Each of my volunteers can be assigned to up to 3 different department.
Each volunteers has a fixed shift for each department that normally doesn't change.
I have the volunteers table with Last Name, First Name, Department 1, Shift for Dep1, Department 2, Shift for Dep2, Department 3, Shift for Dep3.
My goal is to have a report that looks like a weekly calendar for each department.
So for example, I want to have a report for Dep X, where Mon AM shows all the volunteers in Dep X with the Mon AM shift, and Mon PM shows all the volunteers in Dep X with the Mon PM shift etc.
What is the best way to do this?
I tried the following solution:
I was successful in creating the following queries: Dep X Mon AM query, Dep X Mon PM query, Dep X Tue AM query etc. for all AM PM shifts of the week.
I was then trying to create a report that is based on all those queries, but it wouldn't let me complete this report because quote: "you have chosen fields from record sources which the wizard can't connect". I'm assuming this error is because all my queries are based on the same table?
How can I proceed?
Thanks so much!