Hello,
I am trying to use Access to automatically generate watch bills (a list of who will man what watch station for each portion of a 24-hour day based on various factors such as qualifications, skills, injuries, etc).
So far I have created the following tables:
- A table of all personnel with a column for all of their qualifications
- A table of all watch stations and what qualifications are required for said watch station
- A table for all the watches that must be stood in a given week
How can I use Access to automatically generate a watch bill for a given week using these tables?
Thanks!
Max