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

David at softv.net David at softv.net
Thu Jan 17 10:27:47 CST 2002


>> 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