SELECT TOP 100 records or another 100 records

  • Thread starter Thread starter Man Utd
  • Start date Start date
M

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Recordset.clone record count issue 3
datasheet - subforms 2
Deleting many forms or queries or reports 11
How do I get a query to add an incrementally increasing number? 2
Top 100 records 2
insert a deleted record back in access table at the same location 2
Pie chart in columnar report 1

Back
Top