What you want to do is "APPEND" data from one table to the other. Decide
which table you want to "put data into".
open a new query and put "the other" table into it.
Bring down all the fields from the table into your query. on the menu above
choose "query" then "APPEND". Choose the other table and run the query, all
the records will then be appended or added to the table you chose.
You must have clicked the red astorisk running the append query three times.
What do you want to do now? You can run a "find duplicates" query. Go to
queries, select new query, choose "find duplicates" which will start a wizard
allowing you to select the table with all the records in it. The wizard will
build a query that returns all the duplicates and then you can delete them.
Does this help you?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
