Data from multiple database tables

[BarbaraB]

I keep construction bid results in seperate databases (they are different
projects). I need a report showing the results for a single contractor from
all the databases, but not sure how to do this. For instance, a plumber has
bid on 5 different jobs, hence 5 different databases. I want one report
showing all the plumber's bids (name of the job, bid amount, successful,
etc.). Each database has the same structure (contractor name, bid, success).

Help is appreciated.

Barbara

 

[mscertified]

Do you mean different databases (.mdb files) or diffrerent tables in the same
database?
If they are in different databases you will have to have one database link
to the rest via the table linking. If they are in separate tables in the same
database, you need a query to read from all of the tables.
It sounds like you have your databases and tables designed in a way that
makes reporting difficult. You really need to re-think your design.

-Dorian

 

[BarbaraB]

I have different databases. I don't have one database with different tables
in it.

 

[Jeff Boyce]

Barbara

Pardon my intrusion...

If you are keeping each separate project/company/bid in a separate database,
it sounds like you are "committing spreadsheet" on Access. I could see
keeping separate spreadsheets, but you don't need to do that with a
relational database like Access.

In fact, if you do something like that with Access data, you are making
yourself and Access work MUCH harder than either needs to, and you won't get
much or easy use of Access' relationally-oriented features/functions.

If you post a description of the data you are keeping "in separate
databases", and possibly an example, the folks here in the newsgroups may be
able to offer alternate approaches that can make your reporting efforts much
easier.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mscertified]

Is there some good reason why?
For instance are you importing the data from elsewhere?
You really need to get all your data at a minimum in one database but
prerefably in one table in one database.
You can easily get all the tables in one database by importing them (right
click and choose Import) or you could just link to them by right clicking and
choosing Link tables.

-Dorian