Query Criteria

P

PL

Hi
I wish to find the 10 cheapest products from a long table of products. After
creating a Query, but what expression do I enter under the Criteria?

Thanks
 
A

Arvin Meyer [MVP]

You would sort ascending on product price. Then right click on a blank area
of the query grid and choose Properties. On the Property sheet, select Top
Values then type in 10. The SQL of the query will look something like:

SELECT TOP 10 *
FROM tblProducts
ORDER BY Price;

Be aware that if there are duplicate prices, you may get more than 10
answers.
 
Top