bassballs1210
Technical User
- Apr 11, 2008
- 1
Hi I'm a newbie here, hopefully I've posted this question in the right place...if not I apologise.
How can I incorporate a rotating shift pattern in to MS Access. I work on a 4 week rotating shift pattern (see below), I work week 1 -4 , then start again. I'm also on A shift (there ar 3 other shifts B-D). When A shift is on week 1, B is on Week 2, C is on week 3 and D is on week 4.
M T W T F S S -(Weekdays)
N N N -(Week 1) N = Nights
N D D D -(Week 2) D = days
N N N - (Week 3)
D D D D -(Week 4)
(Hopefully - it's aligned correctly)
I need to incorporate this into a database so I can create a tool for personnel on each shift to book time off for any day they are working.
The idea being that, the user selects a date and the database automatically calls shows the shift personnel on the appropiate shift fo that day.
How can I accomplish this (the rotating shift part)in an access database.
Thanks in advance
KD
How can I incorporate a rotating shift pattern in to MS Access. I work on a 4 week rotating shift pattern (see below), I work week 1 -4 , then start again. I'm also on A shift (there ar 3 other shifts B-D). When A shift is on week 1, B is on Week 2, C is on week 3 and D is on week 4.
M T W T F S S -(Weekdays)
N N N -(Week 1) N = Nights
N D D D -(Week 2) D = days
N N N - (Week 3)
D D D D -(Week 4)
(Hopefully - it's aligned correctly)
I need to incorporate this into a database so I can create a tool for personnel on each shift to book time off for any day they are working.
The idea being that, the user selects a date and the database automatically calls shows the shift personnel on the appropiate shift fo that day.
How can I accomplish this (the rotating shift part)in an access database.
Thanks in advance
KD