Finding Median and Upper Quartile

[Andy Chan]

May I know if there is a function for median and upper quartile of a set of
data in MS Access?

 

[Douglas J. Steele]

Sorry, no there isn't.

There's code at http://support.microsoft.com/?id=210581 to calculate Median.

Similar code can be used to calculate quartiles.

 

[James A. Fortune]

May I know if there is a function for median and upper quartile of a set of
data in MS Access?

In:

http://groups.google.com/group/comp.databases.ms-access/msg/7fb6eb508f22fa9d

I give a SQL technique for finding the medians of sets of values
returned by a GROUP BY clause. Perhaps it will give you a starting point.

James A. Fortune