title: In Access97 SQL how do I return a range of rows?
body: <p>I have an Access97 database (unfortunately) and I am querying it over ODBC.</p>
  
  <p>I want to construct a query that will return me J ordered rows starting at offset K.  Right now for a related operation I am using a sub-query and the TOP keyword, this works fine but I don't think I can use it for this new operation I am trying to perform.  I am wanting to do this because I want to add some form of paging to some software.</p>
  
  <p>Ideally the user interface should be able to say, give me 50 records, starting at record 150, sorted by the date column.</p>
  
  <p>Any help would be appreciated.</p>