My Update Table problem.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the logic is "if (field1 is true) or (field2 is true) then update
field 4 to be false.
 
Back
Top