If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i create multiple tables from a master table automatically?
i have a table that includes records for multiple deals (i.e., 100 records
for deal ABC, 125 records for deal XYZ). from that master table, i would like to create separate tables for each deal. creating a query with the general criteria "[Enter Deal Name]" is simple in order to extract the right data. however, how do i go about creating new tables for each deal automatically? it seems that i am not able to put "[Enter Deal Name]" in the table name. Any ideas? |
#2
|
|||
|
|||
On Fri, 16 Sep 2005 16:28:35 -0700, "Panos"
wrote: i have a table that includes records for multiple deals (i.e., 100 records for deal ABC, 125 records for deal XYZ). from that master table, i would like to create separate tables for each deal. creating a query with the general criteria "[Enter Deal Name]" is simple in order to extract the right data. however, how do i go about creating new tables for each deal automatically? it seems that i am not able to put "[Enter Deal Name]" in the table name. Any ideas? Well... one idea is DON'T. You can create a Query based on this table using [Enter Deal Name] on the Criteria line. You can edit the records in this Query; use it as the recordsource for a Report; use it as the recordsource for a Form; you can export it to text, to Excel, to Word as a mail merge; you can even base another query on it. Creating 100 redundant tables is neither necessary nor beneficial; it will bloat your database, take a lot of extra time due to the overhead in creating tables, and subject you to the risk of update anomalies (you have the same data stored in the master table and a derived table, and no protection if one table gets changed and the other doesn't). Am I missing something? Oh... you can create MakeTable queries too. It's just not a good idea. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create a form to enter data to multiple tables? | BevB | Using Forms | 2 | July 5th, 2005 07:05 AM |
fields from multiple tables | dj | Using Forms | 1 | March 3rd, 2005 08:27 PM |
Criterion - How to Write Query for Multiple Tables | jcinn | Running & Setting Up Queries | 1 | February 8th, 2005 12:42 PM |
Delete multiple records from multiple tables in Access? | nalgene | General Discussion | 2 | August 15th, 2004 07:10 PM |
updating multiple tables | Sunny | Using Forms | 2 | July 30th, 2004 06:08 PM |