G
Guest
I want to simply merge two tables into one. Field headings are the same in
each table.
each table.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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.
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.
G
Guest
Create an Append Query and append one to the other.
G
Guest
jeff something went wrong. they appended but three times each . help
G
Guest
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?
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?