Reports from two databaes

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

Guest

I have two databases: 2006 & 2007
Each datbases' report is identical in layout, and each report contains three
subreports.
Can I create a third report by uniting each databases' report, ie: 2006 main
report, 2007 subreport, master and child linked by city?

I really don't want to link the information from one database and redo the
very complicated layout again.
 
Apparently you have similar data in two different databases/table structures.
I would think the easiest method would be to link tables from one to the
other and then combine the tables with union queries. Base your reports of
your union queries.
 
Because of the nature of the queries for the sub reports, I really need to
keep the databases separate, and just combine (report/subreport) the reports
from the two databases
 
You don't have to combine the databases. You can link tables or create a
query that pulls records from another database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subreports show each column on a new page 6
reports from two databases 3
Filtering subreports on main report 0
How to address subreports properties from main report 1
Report with pivot tables and pivot charts in sub reports 6
Using Subreports to create a Main Report 7
Access Subreport Can Grow Problem 2
Reports that sift records from different tables 0

Back
Top