Percentiles

[Tony]

Does anyone know how to calculate a percentile in Access'
Query?

I run reports where I need to show Min, Max, Avg, and a
certain performance percentile, and currently I have to
export the data back into excel to calculate the
percentile.

Given the size of some of the databases I work with, this
isn't feasible.

Any help with this would be greatly appreciated!!

If you could reply to this and attach it to an e-mail
to:whoseyourpoppa(remove this text)@hotmail.com I would
GREATLY appreciate it.

Thanks!

 

[Jeff Boyce]

Tony

One approach would be to reference the Excel PERCENTILE() function from
within Access.

Go to Modules, open one, and select Tools | References. Check the Excel
object model to get at the Excel functions. You may have to do your
calculating from within a procedure.