adding variable data to maketable name

[scottemotive]

Hi

I have a make table query which has a date field within, the criteria is Between [Enter Start Date] and [Enter End Date]

what i want is the results of this criteria to be added to the table name

i.e Start Date 1/11/04 End Date 30/11/04

run query - Make Table - Save Table with name "MyNewTable 1/11/04-30/11/04"

is this possible?

thanks

Scott

 

[scottemotive]

or even get access to prompt for a table name each time its run

 

[Mile-O]

Why are you making extra tables?

If you keep it as a query you can run the dates anytime and save on the waste of space you are currently proposing.

 

[scottemotive]

thanks for the reply,

i need seperate tables as i have pivot table reports connected to the table, each time i run the query it overwrites the table and thus the pivot table

 

[scottemotive]

what i would like is either:

for the make table query to prompt the user for a new table name
i.e
run qry - Prompt for Date to and from - prompt for table name - make table
or
for the table to be made but using the returned data from the date criteria prompt as the new table name
i.e run qry - prompt for date to and from - make table using date to and from as table name

thank you

scott