Make table queries

Thank you for your question

After some consideration it seems the only way to do this would be to write some VBA code that would prompt the user to enter a table name and would then insert that name into the queries SQL and then run the query.

An example of the code required is as follows

Sub MakeTable()



    Dim strTable As String

    Dim strSQL As String

      

    

    strTable = InputBox("Enter table name")

    

    strSQL = "SELECT Employees.Company, Employees.[Last Name], Employees.[First Name] INTO" & """strtable""" & "FROM Employees;"





    DoCmd.Run strSQL

    

End Sub