Reporting/linking across databases

K

Karina M ;)

Is this something I can do? I am an intermediate user at best. I can create
queries and reports, but know no macros or SQL. I'm sick of having to copy
and paste a report 3 times over between DBs. What are my options?
Thanks!
 
K

Karina M ;)

At work we oversee 4 different types of contracts with different contractors,
allowable amounts, etc, which requires the use of various DBs. Yet, the same
staff is doing work acorss contracts so our evaluations take some time since
we have to run numbers per contract.
Let me know what else you need to help.
 
D

Duane Hookom

I haven't heard anything yet that justifies separate MDB files. You can use
the same front end that can change links to different back-ends. You can also
link all tables from the multiple MDBs into a single front-end reporting MDB.
Or you can combine the multiple back-ends into a single mdb.
 

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

Reporting across databases 11
Seperate Databases and Business Logic.. SQL vs. .NET code?? DesignIdeas/Differences 2
Default Printer 1
Report from multiple databases 2
Complex reporting task 6
High-efficiency report design with Excel-like reporting tool 2
Linking queries to reports 6
Which one is better for reporting tool: open source or charge? 1

Top