Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    1

    Unanswered: Access 2010 Report and Median

    Hello,

    I am trying to program an Access 2010 report to calculate the median of a data set. I have tried programming the report using "=Median([Cost])" without success. How can I calculate the median? Any assistance you can provide is greatly appreciated. Thank you.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    afaik there is no median function built into Access, however you could write a function that calculated the median
    How to use code to derive a statistical median
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •