How to calculate median in report footer?

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 ?

Answer 1

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...

Answer 2

Hi I once found this:

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

---

Cheers // Peter Forss Stockholm

Answer 3

DB

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

---

Cheers // Peter Forss Stockholm

Answer 4

DB

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

---

Cheers // Peter Forss Stockholm

Hi Peter,

Thanks!