Join?

[Guest]

I have two tables with the same structure. One is an archive of records from
the other, but there is an occasion where both need to be searched for an
item that may have been overlooked, after the records have been archived. Is
it possible to create a query that will join the two tables, so the tables
appear to be one without a difference in column names (without table
qualifiers)?

 

[Guest]

Use a union query.

Better yet is to add a Yes/No field to your table named something like 'Old'
or 'Archived' and append all records into a single table flagging those
archived records. Then use criteria in your queries to pull non-archived
records unless you want all.

 

[Guest]

I was trying to avoid a single table, as it was getting large, but the UNION
worked, thanks!