Percent

M

Mark

I have a query that is arranged acorting to a number.

Name Money
Dan $150
Steve $60
Mike $20
Paul $10


for a lot more records of course. but i want to be able to decide the
person who is the lowest one in each percent as in if i wanted
to produce the following output

Percentile Money
90% $150
80% $150
70% $60
60% $60
50% $60
40% $20
30% $20
20% $10
10% $10

is there an easy way to produce this?


Thanks
-Mark
 
L

LeAnne

There's one posted at Dev Ashish's site, too:

http://www.mvps.org/access/queries/qry0019.htm

Another option would be to download the trial version of FMS's "Total
Access Statistics," which calculates quartiles, deciles, and centiles
from the 1th to the 99th %ile. Note that the trial version works on
tables only, not on queries.

hth,

LeAnne
 
Top