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?

Product	Col 1	Col2	Col3	Col4	Max
Cherry	3	8	5	3	8
Banana	1	3	5	4	5
Apple	9	1	4	8	9
Orange	4	4	5	4	5

<tbody>
</tbody>

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.