[thelist] Only display first 100 records from access

[rudy]

> So, my question is how can I only display the first 100 records
> from and access database 

  SELECT  TOP 100
        Title,Initials,Surname,Company
      ,Address1,Address2,Address3,Town,Postcode
     FROM MarketingFile
  ORDER BY Company, Surname

change the ORDER BY to whatever you want to have the top 100 by


rudy