title: Require help to get access form to insert values into query
body: <p>Good day,</p>
  
  <p>I need some help with MS Access and a query. My SQL query takes entries from the a table and copies it to the same table with the <strong>month</strong> field changed to a different value. For example it would take all the payroll entries for Jan, copy them and change the month to Feb.</p>
  
  <p>The SQL looks like this:</p>
  
  <pre><code>INSERT INTO example_table (month, field, field, field)
  SELECT "FEB", field, field, field
  FROM example_table
  WHERE month = "JAN"
  </code></pre>
  
  <p>It selects all the entries for JAN and then copies and pastes it into the same table and changes the month to FEB.</p>
  
  <p>My question is, how can I run this query in MS Access to get the "FEB and "JAN" field values (from the above example) from a form? </p>
  
  <p>Maybe the way that I'm trying to do this is not the best method, if there is another way to get the same results please let me know.</p>