Hi,

From: cadillon@f...
Date: Thu, 5 Jul 2001 16:20:07

if you are using ado and asp then try using the pagesuze, pagecount, and
absolutepage properties of your recordset.

> Hello,
>
> If "Select Top 100 * from table order by field" will return top 100
> records, how to make query to get second page, i.e. records from 101
till
> 200?
>
> Thanks
> Giedrius

Cadillon suggested a great solution strategy.  The code for paging through
the result set from any SELECT statement (whether or not it includes a TOP
predicate) appears on pages 501-503 of Professional SQL Server Development
with Access 2000.

BTW, if you are using FrontPage, you can use its Database Wizard to
accomplish the task without any code at all.  See pages 450-464 of
Professional SQL Server Development with Access 2000 for a collection of
examples that demonstrate the ability of the FrontPage Database Wizard to
create code for generating pages in several typical scenarios.

Rick Dobson
www.programmingmsaccess.com
www.cabinc.net
rickd@c... <mailto:rickd@c...>