A
AngiW
Can someone help me figure out why this query is updating when it's not
supposed to?? I've tried pretty much everything, I can't figure it out.
Here's what supposed to happen: If an employee is NOT RN, not mod comp, full
time, has an 8 hour position, has been there 90 days and not terminated
(obviously), update sickavail with 5.33. My table only consists of RN's as a
test and well, it failed. Thanks in advance!
UPDATE Positions INNER JOIN ([Employee Main] INNER JOIN [Accrual Main] ON
[Employee Main].[Employee ID] = [Accrual Main].employeeID) ON
Positions.Position = [Employee Main].Position SET [Accrual Main].SickAvail =
[Accrual Main]!SickAvail+5.33, [Accrual Main].UpdMonthSick = Month(Date())
WHERE (((Positions.Position)<>"RN") AND ((Date())>DateAdd("d",90,[Employee
Main]![Hire date])) AND ((Positions.Hours)="8") AND (([Employee Main].[Mod
Comp])=No) AND (([Employee Main].Status)="Full time") AND (([Employee
Main].Terminated)=No));
supposed to?? I've tried pretty much everything, I can't figure it out.
Here's what supposed to happen: If an employee is NOT RN, not mod comp, full
time, has an 8 hour position, has been there 90 days and not terminated
(obviously), update sickavail with 5.33. My table only consists of RN's as a
test and well, it failed. Thanks in advance!
UPDATE Positions INNER JOIN ([Employee Main] INNER JOIN [Accrual Main] ON
[Employee Main].[Employee ID] = [Accrual Main].employeeID) ON
Positions.Position = [Employee Main].Position SET [Accrual Main].SickAvail =
[Accrual Main]!SickAvail+5.33, [Accrual Main].UpdMonthSick = Month(Date())
WHERE (((Positions.Position)<>"RN") AND ((Date())>DateAdd("d",90,[Employee
Main]![Hire date])) AND ((Positions.Hours)="8") AND (([Employee Main].[Mod
Comp])=No) AND (([Employee Main].Status)="Full time") AND (([Employee
Main].Terminated)=No));