user rename table from maketable query

  • Thread starter Thread starter kathi
  • Start date Start date
K

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.
 
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.
 
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.
Click to expand...

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!
 
Back
Top