Ultimate Newbie Question

[CaptAhab]

I have two tables.

Jim | 50
Tom | 45
Erin | 35

and

Ian | 45
Steve | 55
Elvis | 30

How would I get these to join into on list

Elvis | 30
Erin | 35
Ian | 45
Jim | 50
Steve | 55
Tom | 45

 

[Joe4]

Let's say that your table names are Table1 and Table2.

Go to the Query Builder.
Select New Query, and go to Design View.
Go to View and change to SQL View.
Then paste the following code in the resulting window:

SELECT Table1.*
FROM Table1
UNION
SELECT Table2.*
FROM Table2;

Change table names to the appropriate values for you.

Save & view the results.

Alternatively, you can also use an Append Query to add the values from one table to the other. See Access's help on Action Queries for instructions on that.

 

[CaptAhab]

Worked like a Charm.

Thanks so Much

 

[CaptAhab]

Worked like a Charm.

Thanks so Much