How to display the next 10 records of data

[Guest]

Can someone please help me!!!

In order to select the first 5th records of data with Access, we use TOP 5.
However, I want to display for example:
The next 10 records of data starting from the 5th records.

Does anyone has any ideas?

Thanks

 

[Chris2]

Can someone please help me!!!

In order to select the first 5th records of data with Access, we use TOP 5.
However, I want to display for example:
The next 10 records of data starting from the 5th records.

Does anyone has any ideas?

Thanks

zoya23,

The basic example:

SELECT TOP 10 *
FROM MyTable AS M1
WHERE M1.MyTableID NOT IN
(SELECT TOP 5 *
FROM MyTable AS M2);

Modify to suit.


Sincerely,

Chris O.