make one form from 2 similar tables

O

Officer A.J.

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.
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top