calculating MEDIAN in a query

  • Thread starter Thread starter Tommy
  • Start date Start date
T

Tommy

Hello,
I am trying to calculate the math MEDIAN for a range of value in a table via a query. I understand that Access doesn't have this function (unlike Excel), but an option would be to create code or pass thru from Excel. Any insight on this issue is very helpful. Many thanks.

Tom
 
You can do this, and much much more with Total Access Statistics.

http://www.fmsinc.com/products/statistics/index.html


--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
Hello,
I am trying to calculate the math MEDIAN for a range of value in a table via a query. I understand that Access doesn't have this function (unlike Excel), but an option would be to create code or pass thru from Excel. Any insight on this issue is very helpful. Many thanks.

Tom
 
Back
Top