SELECT TOP 100 records or another 100 records

[Man Utd]

MS Access 2000, is it possible to retrieve the 100 records at a time?

eg.
SELECT TOP 100 *
FROM Employee

I want to retrieve the second 100 record, third 100 records and so on.

 

[Douglas J Steele]

Unfortunately, Access doesn't support that directly.

You'd need to grab the id of the last record selected, then alter your SQL
so that it's

SELECT TOP 100 *
FROM Employee
WHERE SortField > LastSortField

(and, of course, you must have an ORDER BY in the query)