find top ten records

  • Thread starter Thread starter Liz Hansen
  • Start date Start date
L

Liz Hansen

Hi,

I need to create a query that will find the top ten sales in a table but I'm
not sure how to build the criteria.

Thanks in advance.

Liz
 
Try that,
select top 10 will give you only 10 records, and then just order it with the
sale amount desc.

SELECT top 10 Sales, SalePerson
FROM Table
ORDER BY Sales Desc
 
Hi Liz,

You'll need to write query with your sales field in the leftmost sort field
and set its sort to "descending". Next set the "top values" to "10". Mouse
over the tool bar to find "top values" or you can set it using the "query
properties" box.

Ellen
 
Back
Top