What function is used to make top ten query?

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have a product table and I would like to make a query for the top ten
expensive products, How to only remain those top 10 products while hide
other products. BTW, in the Access database sample Northwind database, How
does it to get the top 10 expensive products query, I can't understand even
after checking the design view of the query?
 
I saw this earlier from one of the MVP's

SELECT DISTINCT TOP 10 ModelPrice, ModelName
FROM tblModels
ORDER BY ModelPrice DESC;

Jim
 
In the query design view, make sure the Query Design toolbar is visible
(View, Toolbars, Query Design)

There is a drop down box that displays "All".

Click the drop down arrow and select an option, or enter any number that you
want. Save the query.
 
Back
Top