[brimba]

I have 2 tables and need to copy all the values from one field of tblB to an existing field in tblA.

I am using the RunSQL command from within an Access Macro and have inserted this SQL Statement.

UPDATE tblA SET fieldA = fieldB from tblB

This syntax does not seem to be correct since I am getting error message:
"Syntax error (missing operator) in query expression 'fieldB from tblB'."

Can you please help.

THANKS

[dylanrelos]

try this:
select * into tblB from tblA

I hope these helps.
good luck.

[brimba]

Thanks for answering.
That will not help though..... I need to copy the data from one field of tblB to overwrite the data in another field of tblA.

in other words....
i need to overwrite tblA.fieldA with the values in tblB.fieldB

can you help?