[thelist] Only display first 100 records from access

[Chris Blessing]

I don't think you can do that with Access... I know you can't with SQL
Server (oddly MySQL offers the LIMIT clause).  You have to use RecordSet
paging (rudy helped me out with this a while back).  Check out this great
(as always) article on 4gfr:

http://www.4guysfromrolla.com/webtech/121298-1.shtml

There are several others on that site but I found that the most helpful.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Paul Backhouse
> Sent: Thursday, January 17, 2002 11:34 AM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] Only display first 100 records from access
>
>
> Ok - so is it possible to select between records 100 to 200?
> Now that would be really handy.
>
>
> >>>>>>>>>
> Paul-
>
> I believe with Access you can use the TOP predicate in your sql statement.
> So it would go...
>
> SELECT TOP <n>...
>
> SELECT TOP 100
> Title,Initials,Surname,Company,Address1,Address2,Address3,Town,Postcode
> FROM
> MarketingFile
>
> Chris Blessing
> webguy at mail.rit.edu
> http://www.330i.net
>
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !