title: Get Row Number in Access Query
body: <p>How would I go about fetching the row number (or index) of a particular row that matches a condition?</p>
  
  <p>Example:</p>
  
  <p>If I wanted to select:</p>
  
  <pre><code>SELECT * FROM tblAccount WHERE [Account ID] = 2343 LIMIT 0, 1
  </code></pre>
  
  <p>How would I get the row number of that selected row?</p>
  
  <p>Thanks.</p>