user rename table from maketable query

[kathi]

Is it possible to save a table resulting from a parameter
maketable query with table name the same as the value
entered as the parameter(s)?

I have an address table that is queried for locality or
locality and street. It would be so much better to
specify the table name when the query is run, rather than
each successive query overwriting the results of the
previous query.

 

[Duane Hookom]

You can't do this with a parameter. You could take user input and then
modify the SQL property of the maketable query's QueryDef object.

I will assume there is a good reason to make multiple similar tables rather
than just using a single table with multiple queries or the same query with
multiple criteria.

 

[John Vinson]

Is it possible to save a table resulting from a parameter
maketable query with table name the same as the value
entered as the parameter(s)?

I have an address table that is queried for locality or
locality and street. It would be so much better to
specify the table name when the query is run, rather than
each successive query overwriting the results of the
previous query.

What can you do with a plethora of locality specific tables which you
cannot do with a (properly indexed) Select query returning exactly the
same data? A Select query is MUCH faster than the same query as a
MakeTable; unless you will be using the new table many, many times in
a highly intensive manner, I think you'll be losing not gaining!