Convert query from sql server to Access

[aadebayo]

Please can any one help me to convert this statement to work in Ms Access. It works perfectly in SQL Server.

UPDATE tblCarMileage SET tblCarMileage.NI_NUMBER = tblEmployee.NI_NUMBER
WHERE tblCarmileage.employee_number in (select employee_number from tblEmployee);