title: MS Access Database, Sequential Number in Select query
body: <p>I have a query in MS Access SQL that is grabbing some information from my table. I'd like to include a field in my select statement that shows a integer and increments by X (1,2,3 or other) for each row.</p>
  
  <p>So my data set would look something like:<Br>
  (If incremented by 2)<br><br></p>
  
  <pre><code>Name   SKU     SortOrder &lt;-This is my Auto Increment Field
  Table  XYZ123  0
  Chair  YRZ345  2
  Sofa   UFD355  4
  </code></pre>
  
  <p>I'm not storing sort order in my table I just want to generate these values in Access SQL.</p>
  
  <p>Thank you for your help.</p>
  
  <hr>
  
  <p><strong>Update</strong>
  I've found the following article that explains a few ways to accomplish this through the access program and vba however i'm writting a c# program that's using an Access TSQL query to grab my data and then export into an excel file so i'm not going to be able to add anything to the original database in the Access Program, additionally going the temp table route, they mention it bloating the database.</p>
  
  <p><a href="https://accessexperts.com/blog/2015/07/28/ways-to-do-sequential-numbering-in-access/" rel="nofollow noreferrer">https://accessexperts.com/blog/2015/07/28/ways-to-do-sequential-numbering-in-access/</a></p>
  
  <p>I just want a column of sequential numbering that is created in my select statement, is that not possible?</p>