-----Original Message-----
your syntax for update query is wrong. you cant use from
in update query.
the syntax is: update <table name> set <field name>=
<value> where <condetion>
you can use a select statement as a subquery in the where
part. ensure you use proper braces if you do that.
your query should look some what like that.
Update table1
Set field= (select table2.field
From table1 Inner join table2 on ....
inner join table3 on....
also try using query wizard if you find creating update
query tedious.
.
