Update from one table to another

[compton]

Hi,
Im trying to update records from one table to another using the pk as the condition. However using sql in Access i cannot get it to work. Any Ideas? Sql simplified is below

Update A Set A.Name = B.Name where A.ID = B.ID
(asks for parameter)

Also tried

Update A Set Name = B.Name from B where A.ID = B.ID
Get syntax error missing operator

Thanks

 

[sfreeman@co.mer]

try this...

UPDATE
tblA

INNER JOIN
tblB ON tblA.ID = tblB.ID

SET
tblA.Name = [tblB]![Name]

WHERE
(([tblA].[ID]=[tblB].[ID]));

 

[compton]

it works

Thanks alot for your help