I have an update query that I would like to only update records based on shift (1, 2, or 3). When I place this criteria in it only selects those in the table that is being updated and not those in the table that contains the new or changed data. MY SQL Statement is below
UPDATE Empl RIGHT JOIN [Empl Update] ON Empl.Emplid = [Empl Update].Emplid SET Empl.Employee = [Empl Update].[Employee], Empl.Emplid = [Empl Update].[Emplid], Empl.Department = [Empl Update].[Department], Empl.[Position] = [Empl Update].[Position], Empl.[Job Profile] = [Empl Update].[Job Profile], Empl.Shift = [Empl Update].[Shift], Empl.[Manager - Level 01] = [Empl Update].[Manager - Level 01], Empl .[Manager - Level 02] = [Empl Update].[Manager - Level 02]
WHERE (((Empl.Shift)="1")):
I have tried changing the WHERE Clause to Empl Update="1" but I reveive a syntax error