Make Table Query w/ User defined table name

[joethehoe]

Question for the Access GODS??

What's the proper(syntax)for a make table query where the data base asks the user to input name of the new table??

SELECT [IS USED FOR MAKE TABLE QUERY].*, * INTO [???enter table name???]
FROM [IS USED FOR MAKE TABLE QUERY];

Thanks Jason.G

 

[dhookom]

I doubt this can be done. You could run code that would modify the SQL of the maketable query.

Duane
MS Access MVP

 

[joethehoe]

Hi dhookom,

Then how about just the current date??

 

[dhookom]

I don't think there is any way to make the table name variable. You may need to change the sql of the saved query.

Duane
MS Access MVP

 

[joethehoe]

Thanks for the responce on this

What about a macro??
1. open and run make table query.
2. rename to ???cd date()?? doesnt allow me to build in the new name field???

 

[dhookom]

I'm not sure what your question is. You could rename the table after running the make table query. Is there a reason you are attempting to do all of this? Saving similar structured tables with different names is a bit unusual.

Duane
MS Access MVP