Can access select the larger number?

[TGrady]

I'm just learning to use MS Access. I have a table named "Total time". In that table I have two fields named "hundreds" and "Expr4" (both are number format with two decimal places). What I'm needing to do is have Access select the larger number of the two fields. Is there an expression that can handle this for me? if so please help...

[beacon]

Hi TGrady,

Try this on for size:

IIf([hundreds]>[Expr4], [hundreds], [Expr4]

The expression says, if [hundreds] is greater than [Expr4] then use [hundreds], otherwise use [Expr4].

It will pick the larger number for that single row in your table/query.

Hope this helps,
beacon

[TGrady]

Thank you... I should have known it was something simple.