How to display the next 10 records of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
zoya23 said:
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
Click to expand...

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.
 
Back
Top