title: Increment and record creation based on field value
body: <p>Access 2003</p>
  
  <p>Ultimately I need to create a report for printing labels "Sample ID, Jar x of x".</p>
  
  <p>My table has Sample ID and Number of Jars. Is it possible to create a query that gives me 3 fields: Sample ID, Jar Number, Number of Jars - where the Jar Number creates records in increments based on Number of Jars?</p>
  
  <pre><code>  Query:  Sample ID - Jar Number - Number of Jars
            Sample 1    1            4
            Sample 1    2            4
            Sample 1    3            4
            Sample 1    4            4
            Sample 2    1            2
            Sample 2    2            2
  </code></pre>
  
  <p>The table information is: </p>
  
  <pre><code>  Table:  Sample ID - Number of Jars
            Sample 1    4
            Sample 2    2
  </code></pre>
  
  <p>I want to avoid creating a table record for each jar.</p>