Median

[Doc94]

I am trying to calculate the median of some times taken from a query. The query calculates time from arrival to disposition in minutes. (by multiplying the time by 1440).
My access report can spit out the average of these for all the patients but the median is a different story. I have dound a number of modules that will calculate the median but I do not know where in a report to put the module to make it function.
Any help would be appreciated.

 

[dhookom]

Garry Robinson just posted an article by Chris Weber at Computing the Median (Again)

Duane
Hook'D on Access
MS Access MVP

 

[mp9]

This may also help:

http://www22.brinkster.com/accessory/modules/004.shtml