Need to Compare 2 Fields

[froggiebeckie]

This is probably simple, but then, so am I.

Need to compare 2 fields in a query, and return the larger of the 2 values in a 3rd field.

As in:

Field A=10 Field B=6 I need Field C to = 10.
Field A=5 Field B=6 I need Field C to = 6.


Any suggestions?

Thanks,
BeckieO

 

[BlueIshDan]

Select a, b, IIF(a > b, a, b) As Greatest
FROM table

try that

 

[froggiebeckie]

Yeppers--that works just fine.
Thanks for jump starting my brain.

BeckieO

 

[BlueIshDan]

Any time