[thelist] THE CODE FOR _______> Only display first 100 records from access

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


Cheers David, i completely forgot it was possible with access, use it alot
with sql.



>> So, my question is how can I only display the first 100 records from and
>> access database - I though I knew, but it doesn't seem to work.

strQuery = "SELECT TOP 100
Title,Initials,Surname,Company,Address1,Address2,Address3,Town,Postcode FROM
MarketingFile"






More information about the thelist mailing list