title: SQL statement in VBA
body: <p>I am trying to run the following SQL statement in ACCESS 2013 VBA but am getting errors due to wrong formatting (in this case I get "Semicolon (;) missing from end of statement"). Could anybody tell me what I am doing wrong in the code below please? </p>
  
  <pre><code>Dim dbs As dao.Database
  
  Set dbs = CurrentDb()
  
  dbs.Execute "INSERT INTO TEMP2 ([Study_Date], [Created_By], [Part_Number], 
  [Upper_Tolerance], [Lower_Tolerance], [ID21_Number]) VALUES ([Study_Date], 
  [Created_By], [Part_Number], [Upper_Tolerance], [Lower_Tolerance], [ID21_Number]) 
  FROM RAC_DATA_ENTRY 
  WHERE [RAC_CAP_VALS] = '" &amp; Me.[RAC_CAP_VALS] &amp; "'"
  </code></pre>