Update query based on a query
Posted on 2006-11-09
Good afternoon Experts,
I am working with MS Access 2000.
There is a field called Requestors in a table called Tbl_Credit_Requests.
I need to change the values in this field from the user id to the persons first and last name.
The first and last name will come from Tbl_Employee.
Below is my sql:
Set Requestor = (SELECT E.F_Name & " " & E.L_Name As Requestor2 FROM Tbl_Emp AS E where E.UserId = Tbl_Credit_Requests.Requestor)
Unfortunately, I get an error that states, “Operation must use an updateable query.”
Any advise is greatly appreciated.