Hi,
I have built a database for a 16 week rotation pattern for 4 Team Managers and 4 Key Operatives.
Each Team Manager has a key operative that works on the same pattern as them.
The shift pattern is: 4 days on, 4 off, 4 nights on and 4 off .
My calculations are that it runs for 16 weeks then it goes back to week 1 and repeats the whole process again (16 week cycle)
My tables consist of: W/C Sunday Dates for a year or 2, Staff Table, Rotation of the pattern vs the week number/W/C and also the shift pattern itself for each week of the 16 week cycle.
My select query pulls in all the tables and generates a 2 year shift pattern for all to later display in a form to add holidays etc. and also amend SICK/Overtime.
This will then feed a report.
I have already achieved this for the Warehouse guys who work 5 week pattern and the days work a 7 week pattern (35 Week Cycle)
The 16 week query seems to miss all week 1's pattern off all the TMan1 Group for the whole year?? (qry16WeekPattern)
The same applies for the rest of the groups but for different weeks, TMan2 - Week 9 for the whole year is missing, TMan3 - Week 13 and TMan4 - Week 5.
I'm totally baffled as to why?
Can anyone help with please?