Choosing max number from 2 fields

[creeping]

Hi,

How do you use the MAX function on 2 fields in SQL to then produce the result a new field.

i.e

12, 24

would go to:

12, 24, 24 << this is the max of fields 1 & 2

Cheers

 

[Jon K]

Put this in the Field: cell of a column in the query grid:-

MaxNum: IIf([Field1]>[Field2],[Field1],[Field2])


If the fields contain null values, use the Nz() function:-

MaxNum: IIf(Nz([Field1])>Nz([Field2]),[Field1],[Field2])

 

[creeping]

thanks heaps