Update one tables field data into another table query

[Jgk]

I am cleaning up a old database with a ton of data.



Here is my situation

one table tblcustomer. Has data accountno

another table tblmarketing has field accountno. But no info

the tables have no relationship set up and I need accountno to be updated for all records in tblmarketing for reports to capture for invoicing mktg fees.

i tried a union SQL statement to join tables and got an accurate result for union, but I cannot do a update or append query.

[burrina]

You want an append qry for that. Just add tblcustomer to your qry grid. Add Primary Key and accountno
Then select Append and select destination tblmarketing and run.


HTH

P.S. ALWAYS use a backup copy when testing a new feature.