title: Create duplicate records based on field value Access
body: <p>I have an Access table that has the following fields named tReOrder:</p>
  
  <ul>
  <li>Barcode (Number)</li>
  <li>ReOrder Qty (Number)</li>
  <li>Item Description (Long Text)</li>
  <li>Supplier (Short Text)</li>
  <li>Items per Unit (Short Text)</li>
  <li>Category (Short Text)</li>
  <li>Subcategory (Short Text)</li>
  </ul>
  
  <p>I am trying to create a script or query that will duplicate a record by whatever value is in the ReOrder Qty.</p>
  
  <p>I have tried multiple queries, scripts, spent a few hours googling and cannot find a solution for this.</p>
  
  <p>This is so we can automatically print out enough labels to label what we re-order for our stocks.</p>
  
  <p>Please let me know if more data is needed.</p>