[thelist] Only display first 100 records from access

Paul Backhouse paul.backhouse at 2cs.com
Thu Jan 17 10:35:03 CST 2002


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






More information about the thelist mailing list