make one form from 2 similar tables

[Guest]

I have one table with data from 2006, and one from 2007. The only difference
is that 2007's table assigns an auto number for each record, and the one from
2006 was manually assigned. I want to be able to search both tables with one
search. Each table contains about 25 fields. The fields are number, date,
text, memo and the one auto number.

 

[Allen Browne]

Use a UNION query.

Example:
SELECT Field1, Field2, ID, 'From table 1' AS Source
FROM Table1
UNION ALL
SELECT Field1, Field2, ID, 'From table 2' AS Source
FROM Table2
ORDER BY Source, ID;

Ultimately, it might be a good idea to combine the 2 into one table.