Deciles, quartiles and means

J

jderrig

OK, I wasn't sure if I needed to put this in the query or reports thread...

I am trying to develop a salary survey and have an issue that I am not sure
if Access will accomplish.

I need to create a report that will bring back the top number of:

First decile (point at which 10% of cases fall below)
first quartile (point at which 25% fall below)
median
third quatile
ninth decile

the report needs to look like this:

Accounts--------First Decile----First Quartile---Median---Third
Quartile---9th Decile
< $10 M
$10M -24.9 M
$25M - $50 M

Is something like this possible in Access? I thought about using subreports
but I have SO many of these reports, I would have to have 100+ different
queries to reproduce what I need.
 
Top