How to compare fields

[Guest]

Hi,

I need to compare three numeric fields and pick the greater of the three; I
will then have to use that number in subsequent calculations.

Any help with this will be greatly appreciated.

Thanks.

 

[Guest]

I would like to know the answer to that question also, if you get no better
answer you can use the long way

IIF(IIf(Field1>Field2,Field1,Field2)<Field3,Field3,IIf(Field1>Field2,Field2,Field1)))

 

[Guest]

I would like to know the answer to this question also, if you'll get no
better answer, try this

IIF(IIF(Field1>Field2,Field1,Field2)<Field3,Field3,IIF(Field1>Field2,Field1,Field2)))

 

[John Vinson]

Hi,

I need to compare three numeric fields and pick the greater of the three; I
will then have to use that number in subsequent calculations.

Any help with this will be greatly appreciated.

Thanks.

You may want to look at your table normalization: the need to do this
suggests that you have a one-to-many (one to three in this case)
relationship embedded within each record.

That said... a nasty nested IIF will work:

IIF([A] > , IIF([A] > [C], [A], IIF( > [C], , [C]), IIF( >
[C], , IIF( > [C], , [C]))

You'll need to check the logic and parentheses, that's just off the
top of my head...

John W. Vinson[MVP]