title: Row numbers in query result using Microsoft Access
body: <p>I always use this query in sql server to get Row number in a table:</p>
  
  <pre><code>SELECT *
  FROM   (SELECT *,
                 Row_number()
                   OVER(
                     ORDER BY [myidentitycolumn]) RowID
          FROM   mytable) sub
  WHERE  rowid = 15  
  </code></pre>
  
  <p>Now I am working in Access 2010 and this seems to be not working.  Is there any replacement for this query in Access?</p>