title: MS Access row number, specify an index
body: <p>Is there a way in MS access to return a dataset between a specific index?</p>
  
  <p>So lets say my dataset is:</p>
  
  <pre><code>rank | first_name | age
    1       Max       23
    2       Bob       40
    3       Sid       25
    4       Billy     18
    5       Sally     19
  </code></pre>
  
  <p>But I only want to return those records between 'rank' 2 and 4, so my results set is Bob, Sid and Billy?  However, Rank is not part of the table, and this should be generated when the query is run.  Why don't I use an autogenerated number, because if a record is deleted, this will be inconsistent, and what if I wanted the results in reverse!</p>
  
  <p>This obviously very simple, and the reason I ask is because I am working on a product catalogue and I am looking for a more efficient way of paging through the returned dataset, so if I only return 1 page worth of data from the database this is obviously going to be quicker then return a complete set of 3000 records and then having to subselect from that set!</p>
  
  <p>Thanks R.</p>