In Microsoft Access 2010, I am trying to run the following query:
SELECT tblProcessTime.AutoNum, tblProcessTime.PartType, tblProcessTime.Distributio
nType, tblProcessTime.Para1, tblProcessTime.Para2, tblProcessTime.Para3 INTO [NewTableName]
Where I am assuming that [NewTableName] is a parameter value where Access will prompt the user for a "New Table Name" for the new table that is being created from the "Make Table" query
However when I run the query, the query just creates a new table called "NewTableName".
This is not my intent. My intent is that the user will have the ability to name the new table that is being created by the Make Table query.
Can a Make Table query have parameter values? If so, can it have a parameter value for the "INTO" command portion? If so, please advise how to modify my query.
Attached is the Access database document which has the query named "MakeNewTable" which refers to my above inquiry. If you need anything further, please feel free to ask. Thanks.