Percentile Function For Access SQL?

[billschu]

Hi,

I was wondering if there is a function that will return the kth percentile of a dataset, for instance the 95th percentile of salaries, etc. Or if not, is there another way to do it that may not be as easy? I know there is a percentile function in Excel but not sure about Access.

Thanks,
Bill

 

[MichaelRed]

This has been discused (and solved) in several threads herein (Tek-Tips). Please make use of hte search capability with (initial KeyWord(s) [Pct | Percentile | ... } where the elipisis (" ... ") represents other likely terms.





MichaelRed