Limit search results to 10 per page

[Wendy P.]

HI,

Thank you for answering my previous question - I am up and
running!

Now I am trying to limit the asp results on each page to 10.

Please note that I am using FRONTPAGE 98 and ACCESS 2002,
SQL statements.

Here's my exisiting code...what do I do now? Thanks so much!

SELECT Products.ImageSmall, Products.Category,
Products.ProductType, Products.ProductName, Products.Stock,
Products.AgeGroup, Products.SystemRequirements,
Products.RetailPrice, Products.Manufacturer, Products.Link,
Left([Products.Description],225) AS shortdesc
FROM Products
WHERE Products.Category LIKE '%S%'
ORDER BY Products.ProductType DESC , Products.ProductName;