Combine records from two table of identical format into one recordset

[Ymesei]

How can I create a recordset from the following tables:
Table1
Field1 Field2 Field3
Joe 12 Manhattan
Tom 22 New York
Ed 20 Chicago

Table2
Field1 Field2 Field3
Karen 15 Anaheim
Susan 17 Los Angeles
Jan 22 Seattle
============================================
To combine into a single recordset like this:
Query Output:
Field1 Field2 Field3
Joe 12 Manhattan
Tom 22 New York
Ed 20 Chicago
Karen 15 Anaheim
Mike 17 Los Angeles
Ted 22 Seattle
I don't want to use an append query to populate a temporary table because the process of this will be too slow. This query will be run several times per day based on various criteria and its output used as the source for a report.

Any ideas would be great.

Will

 

[tlbroadbent]

Use a UNION query.

Select * From table1
UNION
Select * From table2 Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[Ymesei]

It worked!

Thanks very much.