Update Values From Table to Another

[Fattire]

I have two tables each with two fields:

tbl1: Check_Number, Mailed_Date
tbl2: Check_Number, New_Mailed_Date

I want to change Mailed Date in tbl1 to the New Mailed Date value in tbl2 where the check numbers match and without recordsets, just using Access queries. I can't get the Access queries to do this.

 

[PHV]

UPDATE tbl1 INNER JOIN tbl2 ON tbl1.Check_Number = tbl2.Check_Number
SET tbl1.Mailed_Date = tbl2.New_Mailed_Date

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[genomon]

Or just use VBA with the SQL above and skip the stored query:
DoCmd.RunSQL "UPDATE tbl1 INNER JOIN tbl2 ON tbl1.Check_Number = tbl2.Check_Number
SET tbl1.Mailed_Date = tbl2.New_Mailed_Date"

Ever notice how fast Windows runs? Me neither.

 

[Fattire]

Nice!

I was getting a "Enter Parameter Value" window - I think the reason was because tbl1 is a linked table to another database

When I imported the tbl2 into the database tbl1 resides it worked perfectly.

Thanks PHV!

I tried the SQL as well and it also worked.