Let me see if I can explain this. I work as a supervisor and have to come up with a schedule for my workers.
There are 3 other supervisors that have to do this same thing. I would like to have all 4 shifts schedules dynamically feed into a work sheet that displays the current assignments for the month.

The shift is based on a 28 days rotation.
We have 4 shifts.
Each shift has 8-10 operators.
There are 8 work stations plus a slot for vacations and for training.
And to make this more complicated, not all operators are qualified in all work stations.

This is how our schedule goes:

M - T - W - T - F - S - S
D - D - O - O - N - N - N
O - O - D - D - O - O - O
N - N - O - O - D - D - D
O - O - N - N - O - O - O

D=days N=nights O=off

I know this probably would be easier to do by interfacing with Access but I don't know Access.
Any help would be appreciated.