Combine two tables with a query - How to?

  • Thread starter Thread starter Shyguy
  • Start date Start date
S

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.
 
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;
 
SELECT statements are usually in a query (View->SQL) or can be used in
Record Source or Row Source properties.
 
Back
Top