update a field in one table from another field

[Earl Takasaki]

Is there a simple way to update a field in one table from a field in another
table? The SQL that works in SQL Server doesn't seem to work in access...

update tbl1 T
set T.field = S.field
from T inner join S on T.field = s.field

 

[Klatuu]

update T inner join S on T.field = s.field set T.field = S.field;