 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Data from multiple database tables
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  SignatureMSOffice 2007 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 > I keep construction bid results in seperate databases (they are different > projects). I need a report showing the results for a single contractor from [quoted text clipped - 6 lines] > > Barbara I have different databases. I don't have one database with different tables in it. SignatureMSOffice 2007 > Do you mean different databases (.mdb files) or diffrerent tables in the same > database? [quoted text clipped - 16 lines] > > > > Barbara 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 >I have different databases. I don't have one database with different tables > in it. [quoted text clipped - 28 lines] >> > >> > Barbara 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 > I have different databases. I don't have one database with different tables > in it. [quoted text clipped - 19 lines] > > > > > > Barbara
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.