title: MS Access VBA - Using SELECT INTO to create a new table and add a record
body: <p>I'm trying to take a record from another table [Process Order] and put it into a new table with the date on it (NewTableName), but I keep getting 'Too few parameters. Expected 1'. I got it to work and pass one field over based on the [Process No] = txtProc or something earlier but can't get it to pass all the fields I need.</p>
  
  <pre><code> Dim strSQL As String
   Dim NewTableName As String
  
   NewTableName = "[Process Order-Oven " &amp; Format(Date, "DD-MM-YYYY") &amp; "]"
  
   strSQL = "SELECT [Run No], [Product ID], [Process No], [Product Description], " &amp; _
            "[Good Product Produced] INTO " &amp; NewTableName &amp; _
            " FROM 'Process Order' WHERE [Process No] = txtProc.Value"
  
   CurrentDb.Execute strSQL, dbFailOnError
  </code></pre>