Calculating median from a recordset!

[sillylady]

I don't think you will have much of a choice. Unless you build arrays for each and order the arrays.

Yeah correct I have to transfer the record in an array. I tried that in a code in my 1st post, but the array holds the last value only. Though the same code transfers the value in each column of the Grid. I don't know where i am making mistakes.