Query two tables w/ different records

[Guest]

I need to query information from two different tables but am not sure how to
link these tables. The fieldnames are the same but the records are
different. In the past I have linked tables but they have always had
information for the same records. I have two tables b/c managment wants a
table for each fiscal year but when I have to run reports, I want records
included from each table. Any ideas?

 

[Brendan Reynolds]

Sounds like you need a union query ...

SELECT * FROM FirstTable
UNION ALL SELECT * FROM SecondTable

You can't create union queries using the graphical design grid, you have to
use SQL View for that.

In the long run, insisting on a separate table for each fiscal year is
likely to make the solution more and more difficult as time goes by, until
it becomes completely unworkable. The correct solution is one table using
queries to separate the fiscal years.