Update Query with Criteria in update to table

[tanner.morgan]

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

[Minty]

Is Empl Update a number or text ?

[tanner.morgan]

it is short text

[Minty]

In that case should it be

 [Empl Update].[Shift] = "1"