Find / Return Max value in a row based on columns

[SOVIETBIKER]

Hello, I am working with a table in Access and I want to find the max value within a row from multiple columns. How would I create a calculation for the max column?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Col 1[/TD]
[TD]Col2[/TD]
[TD]Col3[/TD]
[TD]Col4[/TD]
[TD]Max[/TD]
[/TR]
[TR]
[TD]Cherry[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]9[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]8[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]


Thanks!

 

[GerryZ]

hello!
you said in Access?
because in Excel is =MAX(B2:E2)
Bye!

 

[SOVIETBIKER]

hello!
you said in Access?
because in Excel is =MAX(B2:E2)
Bye!

Yes in Access. That is why I am posting this in the Access Forum. The second piece of this puzzle would be to return the column name associated with the highest value.

I know how to do this in Excel INDEX($H$1:$L$1,MATCH(MAX($H2:$L2),$H2:$L2,0))) Now I need to recreate in Access.