UPDATE with a subquery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Control table with two columns: File and Job. Job is the KEY and
File has the value I want to update another table with.

I want this query to work:
UPDATE tbl_MA_Ext SET File = (SELECT File
FROM tbl_Control
WHERE Job = "9A");

The error I receive is:
"Operation must use an updateable query."

It is guarenteed that only one value will be returned by the SELECT.
 
Robin,

One way would be...
UPDATE tbl_MA_Ext SET File = DLookup("[File]","tbl_Control","[Job]='9A'")
 
Back
Top