W
Will_in_Canada
Hi All!
I have basically an Employee_Calendar table which has 4 shifts per day x
365 days per employee.
A snippet of the table looks like:
EMPL / DATE / SHIFT / STATUS
123 01/01/05 1 Dispatched
123 01/01/05 2 Dispatched
123 01/01/05 3 Available
123 01/01/05 4 Available
123 01/02/05 1 Available
After Shifts 1 and 2 are completed, I want to run an update query using
DoCmd RunSQL that says 'If the employee worked on Shift1 or Shift2 or both,
he /she is ineligible for Shift4 (allnight shift)' So if the conditions are
true, I want to update the Status at Shift4 from 'Available' to 'Ineligible'.
Any ideas?
Thanks in advance!
Will
I have basically an Employee_Calendar table which has 4 shifts per day x
365 days per employee.
A snippet of the table looks like:
EMPL / DATE / SHIFT / STATUS
123 01/01/05 1 Dispatched
123 01/01/05 2 Dispatched
123 01/01/05 3 Available
123 01/01/05 4 Available
123 01/02/05 1 Available
After Shifts 1 and 2 are completed, I want to run an update query using
DoCmd RunSQL that says 'If the employee worked on Shift1 or Shift2 or both,
he /she is ineligible for Shift4 (allnight shift)' So if the conditions are
true, I want to update the Status at Shift4 from 'Available' to 'Ineligible'.
Any ideas?
Thanks in advance!
Will