Reports from two databaes

[sierralightfoot]

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.

 

[Duane Hookom]

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.

 

[sierralightfoot]

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

 

[Duane Hookom]

You don't have to combine the databases. You can link tables or create a
query that pulls records from another database.