UPDATE with subquery answer

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

Guest

After reviewing a posting from Eric Butts [MSFT] dated 6/16/2004, I have come
up with this solution.
1. The Select query is "qry_Control_Job_9A"
SELECT File
FROM tbl_Control
WHERE Job = "9A";

2. The Update query is
UPDATE tbl_MA_Ext, qry_Control_Job_9A
SET tbl_MA_Ext.File = qry_Control_Job_9A.File;

It works. Thanks.
 
2. The Update query is
UPDATE tbl_MA_Ext, qry_Control_Job_9A
SET tbl_MA_Ext.File = qry_Control_Job_9A.File;

It works. Thanks.
Click to expand...

Well... it will work if qry_Control_Job_9A ALWAYS returns one and only
one record. You really should have a JOIN in the query!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top