Median value for multiple columns

[MIS_Analist]

Hi,

I'm trying to find the median value in access like in the form below:

Name Month_1 Month_2 Month_3 Month_4 Month_5 Month_6 Median
Oagaru 15 18 15 15 15 15
Se Vede 10 10 45 10 10 10
Un nimeni 20 20 48 20 20 20

Bassicaly, I have a column (Nume) that has unique values and six columns with number values. I wan't in the column median to obtain the median value for each unique record in "Nume". e.g: for Oagaru, the result in "Median" Column should be 15.
Please take in consideration that this is just a sample and the original table cotains more then 1.000.000 million records, with at least 20 columns, so no normalization or other stuffs like this can be taken in consideration.


Another work-around solution could be to obtain result of the SUM(3rd+4th largest value)/2 since this is the method to calculate the median when you have even numbers, like in this case.

Thanks in advance

[weekend00]

would please describe in more detail about how do you want/get the MEDIAN?

I think you need VBA codes to do the calculation.

[ajetrumpet]

well, you know how to get the median value already, so...try applying this code in your query: http://www.ajenterprisesonline.com/_...me=SumFields()

it will have to be modified of course, but like weekend says, the query builder cannot do calculations horizontally. you have to resort to code.