Selecting top 10 from a list

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
 
J

John Spencer (MVP)

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).
 
G

Guest

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...
 
Top