update some fields in one table from another table
have attached sample:
how can i write update statement-to update Table2 with data from Table1?
The fields in Table2 that are not in Table1 - i want the data to remain in the fields - when it is updated
thank you Database2.accdb