How to create a consolidated report from 2 separate Access files

[mashco]

We have 2 separate Access files (databases) - one for each company branch or
site. These files are identical in structure and are maintained as separate
databases. However, recently there has been a requirement to create a report
that will be based on the data from both files.

How can such a report be created? Can these files be linked to get a
consolidated query without importing the data from one file into another?

Thank you.

 

[Brendan Reynolds]

You can create a link to a table in another MDB or other data source. From
the File menu, select Get External Data then Link Tables.

To create a report that consolidates data from the two tables you could
create a union query. You can't create this type of query using the
graphical designer, you have to write the SQL by hand. You can use the
graphical designer to create a normal select query that gets data from one
table, then switch to SQL view to change it into a union query that selects
from the two tables.

If you type 'union query' into the 'type a question for help' box near the
upper right-hand corner of the main Access window, you'll get a list of
relevant help topics. (At least, you do in Access 2003).