Using Update Query to update table values

[SHAWTY721]

I have a database that contains some values that I need to be updated if they match old codes that need to be updated. I have the values in two tables. One table contains all the values possible from the imported data. While the other table just includes the 4 digit codes for the old value and the new value.

I am trying to write a Update query that will replace the old values with the new values needed for lookup purposes used on the form.

 

[JerryKlmns]

May be

UPDATE TableOfCodes As N Inner Join TableOfNewAndOldCodes As A On
       N.CodeField = A.OldCodeField
SET N.CodeField = A.NewCodeField;