How to get only a range of records from an Access DB?

Discussion in 'Programming' started by aab1, Apr 1, 2011.

0
  1. #1
    My DB has too many records and I want to break them across several pages. I know how to do it all except how to return only a specific range of records, for example if I wanted record 100 to 200, how would I do this?

    This is the code I now use to get all records:

    "SELECT * FROM MyItems ORDER BY EndTime DESC"

    So how would I change this to get only items 100 to 200?

    This is access so LIMIT and OFFSET don't work.

    Thanks
     
    aab1, Apr 1, 2011 IP