Calculating Percentiles in Querries

[Tristin]

I have a need to create a query that calculates the 25th, 50th, and 75th
percentiles in one query.

If you can send me the formula, that would be fabulous.

[email protected]

(I am on a friends computer who doesnt know a percentile from a latte)


Thanks,


M

 

[Michel Walsh]

Hi,


If there is no NULL values under the column you consider, you can try
http://www.mvps.org/access/queries/qry0019.htm



Hoping it may help,
Vanderghast, Access MVP