Calculate Median

[Xueqing Gao]

It would be deeply appreciated if anyone could tell me how
to use Access to calculate the median value and percentile
of a group of data in a query. I can find the aggregated
functions to calculate mean, maximum value, and minimum
value. But I could not find functions to calculate median
and percentile. Help on this issue is deeply appreciated.
Thanks in advance!

Xueqing Gao

 

[Douglas J. Steele]

http://support.microsoft.com/?id=95918 shows one way to write a function
that calculates the median.

You should be able to modify that code to figure out percentiles as well.