bottom 20

[jamesd]

I have a list of which i need to find the top 20 and the bottom 20.
The list varies in length time I run the qry that makes the list.
Alson there maybe more than one of each number.
The top 20 is easy as I just put <21. But how do I get the Botttom 20
Regards

 

[birdman]

you can use the sort function. if you sort the column from greatest to least, the first 20 values will be the bottom 20. HTH

 

[jamesd]

BOTTOM 20

This will not work as the list will contain more than one of each number.
What I need is the bottom 20 values not just the bottom 20 entries.
So like the top 20 there will be more than 20 entries.

 

[Norie]

James

Have you tried birdman's suggestion?

I just did where there where multiple records shared a value that was in the bottom 20. More than 20 records were returned.