Dear All,
I have a table with 3 fields and I would like to insert a forth and fifth field that would calculate the max and 2nd highest value for each record (I mean the max 2 values out of the three fields)
Eg.
Field1---Field2---Field3---Newfield1------- Newfield2
2---------3------- 4------------4---------------3
5---------6---------5-------------6---------------5
6---------6---------3------------6---------------6
Could you please help me how to achieve that?
Many thanks!!
I have a table with 3 fields and I would like to insert a forth and fifth field that would calculate the max and 2nd highest value for each record (I mean the max 2 values out of the three fields)
Eg.
Field1---Field2---Field3---Newfield1------- Newfield2
2---------3------- 4------------4---------------3
5---------6---------5-------------6---------------5
6---------6---------3------------6---------------6
Could you please help me how to achieve that?
Many thanks!!