Merge Tables

[Mardley O.]

How to combine two or more tables contain the same data format. Say I have
tables contains Work Order #1 and another table contain Work Order #2 and so
on, I want to merge these tables and make them just one Work Order table.

TIA.

Mardley.

 

[Guest]

Create a query from work order #2 table selecting all the fields. Change the
query type into an append query selecting work order #1 as the destination
table.
Run the query and all work order #2 records will be appended to the work
order #1 table.

 

[Mardley O.]

Thanks Dennis!

You solved my problem.

Mardley.

Create a query from work order #2 table selecting all the fields. Change
the
query type into an append query selecting work order #1 as the destination
table.
Run the query and all work order #2 records will be appended to the work
order #1 table.

 

[Tanis]

You can use an append query. Create your query using the query grid
Select all the fields. Click on Query in the toolbar and choos
Append Query. Choose the table from the dialog box and run the query