Combine two tables with a query - How to?

[Shyguy]

I have two tables, one the working table and the second is an archive
table of older records. I would like to combine both tables with a
query to do an historical report. I'm guessing this is easy but I
can't figure it out. ;-(

Any help is greatly appreciated.

 

[Duane Hookom]

If the table structure is nearly the same, you should be able to use a union
query.

SELECT FieldA, FieldB, FieldC,...
FROM tblWorking
UNION ALL
SELECT FieldA, FieldB, FieldC,...
FROM tblArchive;

 

[Shyguy]

Thank you so much!! ;-)

 

[Guest]

Duane,
Where is the select statement placed? Is it in a macro?

 

[Duane Hookom]

SELECT statements are usually in a query (View->SQL) or can be used in
Record Source or Row Source properties.