none
How to calculate median in report footer? RRS feed

  • Question

  • I have a report that generates from a query in Microsoft Access. Each record that is pulled into this report has a number value for the field CallRcvd to Arrival.

    I am trying to calculate and display in the report footer the median of CallRcvd to Arrival on only the records that are pulled into this report. How can I go about this ?


    Tuesday, September 11, 2018 3:28 PM

All replies

  • Hi,

    Since there isn't a built-in median function in Access (as far as I know), you'll probably have to create one yourself. To apply it to only the records within the report, you might try using a recordset object based on the report's record source.

    Just my 2 cents...

    Tuesday, September 11, 2018 4:25 PM
  • Hi I once found this:

    https://bytes.com/topic/access/answers/924954-median-function 


    Cheers // Peter Forss Stockholm

    Tuesday, September 11, 2018 5:05 PM
  • DB

    Concrats to your 20 000 Points (as to Tuesday 11 of September 2018)


    Cheers // Peter Forss Stockholm

    Tuesday, September 11, 2018 5:07 PM
  • DB

    Concrats to your 20 000 Points (as to Tuesday 11 of September 2018)


    Cheers // Peter Forss Stockholm

    Hi Peter,

    Thanks!

    Tuesday, September 11, 2018 5:09 PM