My Update Table problem.

[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

 

[Sirocco]

Use the logic is "if (field1 is true) or (field2 is true) then update
field 4 to be false.