selecting the bottom 10% instead of the top 10%

[basement131]

Using MS access 2000
is there a way to select the bottom 10% as apposed to selecting the top10%.
i know i could change the sorting to descending and then select the top10%, but then i would have to resort my sample after.
is this the only way to do this without 2 steps.


Your help & assistance today will be passed on to others tomorrow.

 

[mp9]

How about this finding records that have no match in the top 10%, i.e.

SELECT YourFieldName
FROM YourTableName LEFT JOIN (SELECT TOP 90 PERCENT YourFieldName AS Expr1 FROM YourTableName) AS Temp ON YourTableName.YourFieldName = Temp.YourFieldName 
WHERE Temp.YourFieldName Is Null;

http://www22.brinkster.com/accessory/

 

[mp9]

Oops, I of course meant "have no match in the top 90%"

http://www22.brinkster.com/accessory/