update in access 2007

[drstein]

I would like to know what the sql is in access 2007 to update 5 columns in one table that is joined to a second table.

 

[epon78]

UPDATE Table1 
INNER JOIN Table2 
ON Table1.KeyField = Table2.KeyField
SET 
    Table1.Field1 = 'a', 
    Table1.Field2 = 'b',
    Table1.Field3 = 'c',
    Table1.Field4 = 'd',
    Table1.Field5 = 'e'
;