Update Multiple Value

[eyeseven]

Hi Guys, Please help me to run this query.

I have Two Tables :

Table_01
Employee_Number
Employee_Name

Table_02
Employee_Number
Employee_Name

My table_02, contains updated name of the customer in Arabic,
and I want to update the Table_01 Employee Name with Table_02.

I have hundred records, I want to create a query where i will update the Table_01 Employee Name from Table_02 Employee Name according to Employee NUmber.

Thanks so much!

 

[JHB]

The below link shows some examples:
http://www.fmsinc.com/microsoftaccess/query/snytax/update-query.html