Work Schedule

Im trying to create a shift Schedule that seperates officers into there
working shifts by criteria of Seniorty and Rank.

There are 5 shifts... Days6am-2pm, 7am-3pm), Afternoons(2-10,4-12),
Mids11-7)

Officer places a bid of the 5 shifts they wish to work to the least
wanted....

Example: Ofc. Example

Choice#1 2pm-10pm, Choice#2, 7am-3pm, Choice#3 4pm-12am .... and so on

Senoirty is based off of Date of Hire, and if Officers have the same Date of
hire, then the officers are ranked... 1, 2, 3

*Not all Officers are ranked*

Im trying to make a database where you place officers name, Date of Hire,
Rank (if applicable) and then choices

compile up the date and place into the 5 shifts and have about roughly 30
Officers for each shift....

Once the spots are filled, then choice two comes into play... and once the
next shift spots are filled...then choice 3 comes into play....

Im kind of at a loss where to start, and this is something I been trying to
work at instead of doing it all by hand... if anyone can help, I would be
grateful...



Thanks..

Officer begging for an afternoon spot