How do i calculate the median in access?

[Belinda7237]

I have 100K rows of data and I want to be able to calculate the median of my
field - how do i accomplish this? I dont see median as an option?

 

[Bob Barrows [MVP]]

I have 100K rows of data and I want to be able to calculate the
median of my field - how do i accomplish this? I dont see median as
an option?

This article discusses a couple of the ways:
http://databases.aspfaq.com/database/how-do-i-calculate-the-median-in-a-table.html

More discussion can be found here:
http://groups.google.com/groups?as_...08&as_maxd=30&as_maxm=7&as_maxy=2008&safe=off