Calculating medians in Access

[David]

How can I easily calculate the median in an Access query?

 

[LeAnne]

Hi David,

Unfortunately, there's no easy way. One possibility is to create your
own custom Function using VBA. You'll find some example code at

http://support.microsoft.com/default.aspx?scid=kb;en-us;95918&Product=acc

for versions A97 and older, or at

http://support.microsoft.com/default.aspx?scid=kb;en-us;210581&Product=acc

for A2K on up.

Another option would be to call the Excel MEDIAN() worksheet function
from within Access. Read about it at

http://support.microsoft.com/default.aspx?scid=kb;en-us;153748&Product=acc

or look in the OLH under Automation.

hth,

LeAnne