maximum

[Majed]

Hi to all;
I am not familiar with access function, in Excel its very easy to find the max value at row level, what's the formula in access query to get the max of this example
Co1 co2 co3 ….co60 max(co1:co60)
200 150 300 500 ?
212 542 321 222 ?
thanks in advance for respond
Majed

 

[MStef]

Look at Access Help "DMax Method".

 

[Majed]

Look at Access Help "DMax Method".

DMax Method is for finding maximum value at coulmn level, I need the max at row level
thanks

 

[Rich]

Access is totally different from Excel, it doesn't support that method, however it looks as though you're trying to re-create a spreadsheet within Access and therefore have a structure problem