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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top Ten Albums 10
Single Query for Top 10 of Multiple Items 1
Top ten records 3
Finding the top ten fastest persons 12
top ten filter 2
Extra spaces at top of page 1
Top Ten Records Displayed by a value 3
Retrieving fieldnames stored in one table and use them in another 5

Back
Top