Max from rows

[irfan.rangrej]

Hi,


I have 6 columns & 6000000 records in a Access 2003 table, 4 out of 6 columns contains numeric values.
In 6th column I need the header of the column which contains the max value.

Example:

mdn column1 column2 column3 column4 max
9824 1 2 1 column2
9825 4 3 8 column3
9826 7 6 8 column4
9827 5 4 21 2 column3

In above table max column contains the header of column which contains the max value.

in first record column 3 has no value, for 2nd record column4 and 3rd record column1 has no values.

Please suggest how can make it.



Regards,
Irfan

[alansidman]

Using this ms access max value in a row in a google search returns several means to do this.

[irfan.rangrej]

Thanks alan,

I got max value in a column, but i need the field name instead of value.

Reg,
Irfna

[irfan.rangrej]

I got the solution

Re,
Irfna