1 report from multiple databases?

[Wrecker]

I have several databases that are the same design,just collecting data from different machines. I would like to create a single report that gathers data from a query (in each database. Is this possible? Do I have to write code to open each database before I can run the report? Still learning....

Thanks
Wrecker

 

[LittleSmudge]

My approach would be to open a recordset on each remote database.

You could then write ther data to a single local temporary table & base your report on that

OR

If the report is simple enough - just calculate your values and populate the report.



G LS