How do I pull data from two databases into one report?

[Guest]

I have two completely seperate databases - running at the same time with the
same information available on them, I need to pull the information from both
data bases into one report for a overall summary report is this possible???
I have linked both tables into the same access report database and that works
fine, and created multiple queries but I cannot get the information together
to make a single report. Is this possible and how do I do this?

 

[Duane Hookom]

You may be able to create a UNION query based on the two linked tables. Then
base your report on the union query.

 

[Allen Browne]

Use a UNION query as the source for your report.

A union query statement likes like this:
SELECT * FROM MyTable1
UNION ALL
SELECT * FROM MyTable2;