Selecting top 10 from a list

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Is there an easy way to write a query that will select the
top ten from a list. For example say you have a number of
sales reps working for you and you want to know who were
the top ten performers for the last month. All the data is
loaded in a relevant table in an access database in which
a query can be written to give an output with the
following headings:

Month Rep_Name Sales_Revenue
 
SELECT TOP 10 Rep_Name, Sales_Revenue
FROM TableName
WHERE [Month] = 2
ORDER BY Sales_Revenue Desc

This can give you more than 10 rows if there are ties for the last position(s).
 
Thanks.

I've tried it and it works fine

Graham

-----Original Message-----
SELECT TOP 10 Rep_Name, Sales_Revenue
FROM TableName
WHERE [Month] = 2
ORDER BY Sales_Revenue Desc

This can give you more than 10 rows if there are ties for the last position(s).


Is there an easy way to write a query that will select the
top ten from a list. For example say you have a number of
sales reps working for you and you want to know who were
the top ten performers for the last month. All the data is
loaded in a relevant table in an access database in which
a query can be written to give an output with the
following headings:

Month Rep_Name Sales_Revenue
Click to expand...
.
Click to expand...
 
Back
Top