Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

make table from queries

Status
Not open for further replies.

robdunfey

Technical User
Apr 26, 2002
110
GB
I have 10 db's. In each db I have a query. I want to make a single table in one db that is the sum of all the queries. There is a common field in each query, SITE_ID, there should be no duplication. Eg Query in DB1 might have sites 1-10, query in DB2 might have sites 11-20, etc. I want a table that lists sites 1-20?

What is the simplest way? I am sure there must be a really straightforward way?

Any help much appreciated.

Rob
 
Hi:

Is the query in each db based on a table? If so, from the "Main" database link the tables from the other 10 databases. Then write your master query using the data from the 10 linked tables.

But, why not have just one database with 10 tables? Or, better, one database with one table with a qualifying field for whatever makes a site-id different from other site ids? Oh well... Gus Brunston [glasses] An old PICKer, using Access2000.
 
Its a problem I have inherited. I have several DB's with the same set of tables with the same names and the queries already exist. But I dont know how to turn the contents of a query into a table?

Thanks for the reply.
 
Hi Rob:

From the built-in menu, select Query, then Make-Table Query...

When you make a table from a query, the previous data in the table is deleted, and the new data "does not inherit the field properties or the primary key of the previous table". (From Help)

Before using a make-table query, you should certainly back up the data, and study Help, which in Access 2000 is quite complete about this subject.

Note: Because you inherited a database design does not mean that it can't be re-designed. As long as the data is intact, no matter where it is, it can be linked to a newly designed front end, and even collected together into a new back end. An old design is not sacrosanct just because it's antique.
Gus Brunston [glasses] An old PICKer, using Access2000.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top