title: Add autoincrement to existing query (not table) in MS Access 2016
body: <p>I have query in MS ACCESS 2016 that I need to add autonumber to. Basically, the query output results in one column of data and I want to add a new column to this output with numbers starting from 1 to whatever the row count of the query output will be. I dont want to create a new table from my query output though. Is there a way to do this in a query? I managed to add a new ID column that just has a scalar value, however what I need is auto increment here. Any thoughts?</p>
  
  <pre><code>SELECT qry.ColA, 1 AS ID
  FROM qry;
  </code></pre>