add 2 tables together

D

David

Hi,

I have 2 tables with the same column titles. all I want to do is to make 1
table which includes the data from both tables.

Thanks for your help

Dave
 
M

Micah Chaney

Create a Query based on the table you want to add to the other one.
From the File Menu | Query | Append Query
Choose the Table you want to add the data to.
If the field names match "exactly" as you say...then the Query will match
the fields up for you.
Run the Query by clicking the Red ! or File Menu | Query | Run
That's it...Good Luck
 
T

T Martin

Create a union query. (Create a new query in design mode, don't select any
tables and there should be a button on the top right of your screen that
says SQL): Use the following statement:

Select * from tbl1
Union Select * from tbl2
Order by SortField
 
D

Douglas J. Steele

If you want to do this permanently, use an Append query to add the data from
one of the tables to the other one.

If you just want to do it temporarily, you might consider using a Union
query to join the two tables together.
 
Top