How can I only take 10 rows at time, and not just the last or first 10.

[alonalon]

I hope I am posting this in the right forum.

This is what I need:

Lets say I have 100 rows in my DB, If I use "TOP 10" it will give me the first 10 rows, but lets say I want to get the second 10 row, of the 3rd 10 rows, how do I do that, I'd really appreciate if anyone could help me, thanks and have a great day.

[help_me_with_access]

you can't do it with the program itself. it's impossible. you have to use its development environment. but say for instance, your records are numbered perfectly via an incremental autonumber. in that case, this sql would give you records 11-20:

select * from table where autonumber between 11 and 20

but that's not practical because it never happens. hence, you need to code it.

[orange]

Try working with your table based on this sql which works fine in Access 2003.

SELECT TOP 2 tblIncidents.IncidentId as X
FROM tblIncidents where IncidentId  Not in
(SELECT TOP 1 tblIncidents.IncidentId as W
FROM tblIncidents)

I have a table with 3 records, this gives me items 2 and 3.

First time use Top 10

Second run do Top 10 (....Top 10....)

Third do Top 10 (...Top 20....)


The key to this in my view is the subquery