Top Ten

[Marlene]

Hi, I am new to MS Access and have written a fairly straight forward
reporting of our Technicians Sales, but my boss wants to see only the "Top
Ten". I have the reporting counting each row, but how do I get it to stop at
10 for each Group?

Any help is greatly appreciated,

Marlene

 

[Klatuu]

You can use the TOP predicate in a query for the record source of the report:

SELECT TOP10 .... FROM....

However, you may get more than 10 rows. That is because it returns the top
10 values, not the top 10 rows. For example, if two salesmen both sold
$900,000 and that was anywhere in the top 10, you would get 11 rows, because
more than one record has the same value.

 

[John Spencer]

It returns the top 10 including ties for the last position. So if the
top 2 amounts were 900,000 and all the other values were unique, you
would get 10 records. If position 10 and 11 had 900,000 as the amount
then you would get 11 records as long as no other records had 900,000.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Klatuu]

You are correct.