This problem is more about programming in SQL-Server than it is about ADP.
Take a look at m.p.sqlserver.programming or make a search on Google with «
sql paging record » and you will find many methods of paging under
SQL-Server.

Signature
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
> Hi,
>
[quoted text clipped - 5 lines]
> Thanks
> Anbu