How do I use 2 database to make 1 report?

[Johan Arief]

Hi, I want to make reports from 2 different database, each date will be set
as 1 database. Can anyone help me for this?
The reports will looks like this
James 31 Jan 04 10 Feb 04 15 Feb 04
Saving 1000 2000 3000
Deposits 2000 3000 4000
Total 3000 5000 7000
Sunny
Saving 5000 3000 1000
Deposit 1000 4000 5000
Total 6000 7000 6000

For 31 Jan 04 will be named as 31Jan04.mdb
For 10 Feb 04 will be named as 10Feb04.mdb and so on for each day.
Thanks for your help.

 

[Douglas J. Steele]

I would strongly recommend against doing what you're suggesting. Relational
databases should NOT be built that way.

All the data for what you're illustrating should be in a single table in a
single database.

 

[Johan Arief]

Hi Douglas,
Thanks for the comments. Is that mean I can't create a report using more
than 1 database in access? Do you know any other way such as using Crystal
reports to create the reports like below? The database(mdb) for each date is
coming from MS SQL which exported to ms access. What I'm doing is I have to
process each mdb for each day(already named by date) for each name. Any
suggestions?

 

[Douglas J. Steele]

Sorry, I don't know enough about Crystal Reports to comment on it.

One option in Access would be to have a single database that links to all of
your other databases, and produce the reports in that database.