Hi

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

Thanks

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.

Hi Danny

Hi Danny

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.

Thanks

No need to make a table. JUst create your Select query and export from the query.

HTH

Thanks Scott

glad to assist