G
Graeme
I am trying to perform an update query using 2 tables. The first table is a
billing file with many records per employee id [EmployeeID] and there is also
an employee name field [EmployeeName]. However, some of the data in this
employee name field is missing. The second table shows the employee name for
each employee id; the fields are [Name] and [EmployeeID]. I am trying to
update the employee name field in the first file using the second file, and
using the driver id as the link. This is what I am using but I am getting
the above error message:
UPDATE [Employee List] INNER JOIN [Billing file] ON [Employee
List].EmployeeID = [Billing file].EmployeeID SET [Billing file].EmployeeName
= [Name]
Thank you in advance.
billing file with many records per employee id [EmployeeID] and there is also
an employee name field [EmployeeName]. However, some of the data in this
employee name field is missing. The second table shows the employee name for
each employee id; the fields are [Name] and [EmployeeID]. I am trying to
update the employee name field in the first file using the second file, and
using the driver id as the link. This is what I am using but I am getting
the above error message:
UPDATE [Employee List] INNER JOIN [Billing file] ON [Employee
List].EmployeeID = [Billing file].EmployeeID SET [Billing file].EmployeeName
= [Name]
Thank you in advance.