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.

 

[Dennis]

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.