PLZ HELP !!!!!!!!!!!

  • Thread starter Thread starter Mita
  • Start date Start date
M

Mita

Hi

Am trying to create the max expression in Access. Need the Max
expression for 3 columns , row-wise in a single table

Column1 Column 2 Column3
200 300 100

max in excel would be Max(Column1, Column2, Column3), however when i
try this in access, it simply does not calculate.

Plz help

Mita
 
IIf(Column1 > Column2, IIf(Column1 > Column3, Column1, Column3), IIf(Column2
 
Back
Top