need to display median

[K.Lear]

I need to display a median figure from a list of numbers, and that funtion
does not seem to be available in Access. Does anyone have a way to build an
expression to generate a median (not a mean/average)?

Thank you.

 

[Douglas J. Steele]

Check my October, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html