A
Andy.R
I am using microsoft access 2002 and want to create a form based on Employee
rosters, which displays who is working on any given day and whether they are
working days or nights. The rosters are made up of 'Shift patterns' which are
rotated on a 40 week cycle, I have allocated a 'Day number' to each day of
the 40 week cycle, there are a total of 56 different shift patterns, each of
which I have allocated a 'Shift code'.and created a table of shift patterns
with the 'shift code' as the column titles and the day number as the primary
key). each Employee is allocated a shift code depending on the days/nights
they work,
I am trying to get the form to return the value from the 'shift code' column
(ie. column 1, column 2, column3 etc.) from the 'shift patterns' table,
specified by the value of the 'shift code' field in the Employees Table
rosters, which displays who is working on any given day and whether they are
working days or nights. The rosters are made up of 'Shift patterns' which are
rotated on a 40 week cycle, I have allocated a 'Day number' to each day of
the 40 week cycle, there are a total of 56 different shift patterns, each of
which I have allocated a 'Shift code'.and created a table of shift patterns
with the 'shift code' as the column titles and the day number as the primary
key). each Employee is allocated a shift code depending on the days/nights
they work,
I am trying to get the form to return the value from the 'shift code' column
(ie. column 1, column 2, column3 etc.) from the 'shift patterns' table,
specified by the value of the 'shift code' field in the Employees Table