S
scubadiver
I want to update information from "Sheet1" to "department". The fields I want
to copy from and to are both called "rate" and I want to match "EmployeeID"
(the same in each table). Here is my SQL:
UPDATE Department
SET [Department]![Rate] = [forms]![sheet1]![rate]
WHERE ([forms]![sheet1]![employeeID]=[Department]![EmployeeID]);
I get an "Enter Parameter Value" box for "forms!sheet1!rate". Not too sure
what is going on. Is my SQL correct?
to copy from and to are both called "rate" and I want to match "EmployeeID"
(the same in each table). Here is my SQL:
UPDATE Department
SET [Department]![Rate] = [forms]![sheet1]![rate]
WHERE ([forms]![sheet1]![employeeID]=[Department]![EmployeeID]);
I get an "Enter Parameter Value" box for "forms!sheet1!rate". Not too sure
what is going on. Is my SQL correct?