Feb 14 2005, 11:43 AM
I want to use the same make-table query that retrieves data based on a policy number. I want to use the policy number as the name for my table created by the query. Is there a way, similar to using the square brackets in the criteria line to provide a message input box that will allow me to determine the name each time the query is run, or do i have to create it in a macro
Feb 14 2005, 11:55 AM
Welcome to UA!!
There is a way but why are you storing the data in seperate tables for each policy?
This is not normalised.
What are you trying to achieve.
Feb 15 2005, 02:01 PM
Thanks for the welcome
The data is stored in one table. The table has close to a million records. What I am doing is extracting out 1 policy's data so that i can see all of the accounting for a set time period. I then move it into Excel to use a Pivot table to reconcile the accounting entries. I don't want to have to go in and change the table name that is being created in the query each time i run it as i may be auditing more than one policy at a time and i don't want to overwrite the records i have extracted.
Feb 15 2005, 02:07 PM
No need to make a table. JUst create your Select query and export from the query.
Feb 15 2005, 02:11 PM
Feb 15 2005, 03:37 PM
glad to assist
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here