Complex Update syntax

[ricksil]

How would I do an "update from" in MS Access SQL Syntax? I tried this and no luck:

update table1 t1
set    col1 = t2.col1,
       col2 = t2.col2,
       col3 = t3.col3
from   table2 t2,
       table3 t3,
       table4 t4
where  t1.col4 = t2.col4
and    t1.col5 = t2.col5
and    t1.col6 = t2.col6
and    t1.col7 = t4.col7
and    t1.col8 = 'X'
and    t2.col9 = 'ABC';

[ItsMe]

Maybe you can cerate a SELECT query using table2, table3, and table4 and save it and name it. Then, create another query using Table1. Turn the second query into an Update query and drag the query you created earlier onto the design surface of your second query.

[ssanfu]

Try this

UPDATE Table1 AS T1, 
       Table2 AS T2, 
       Table3 AS T3, 
       Table4 AS T4 

SET T1.col1 = T2.col1, 
    T1.col2 = T2.col2, 
    T1.col3 = T3.col3 

WHERE (((T1.col4)=[T2].[col4])
   AND ((T1.col5)=[T2].[col5])
   AND ((T1.col6)=[T2].[col6])
   AND ((T1.col7)=[T4].[col7])
   AND ((T1.col8)='X')
   AND ((T2.col9)='ABC'));

[ricksil]

That did the trick. Thank you!!!