I would like to be able to update existing records and insert new records into a main table from another table.
Is this possible using append query to do the inserts and update query to change the data on existing records?
I have been trying to do an append query to append new records into the main table if they don't already exist another table. Then doing an update query to update the existing data in the main table?
How may this be done or is it better doing it with a macro or code