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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You may be able to create a UNION query based on the two linked tables. Then
base your report on the union query.
 
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;
 
Back
Top