finding the greatest value of 3 possible numbers

[cowboy]

How do I find the greatest value of 3 possible numbers, and if the user didnt fill in one of the numbers it will be a Null value

This is how I am currently finding the greater of 2 numbers, but I dont like it:

Temp2: IIf([Right Side] Is Null,0,[Right Side])
Expr1: IIf([Left Side]>[Temp2],[Left Side],[Right Side])



Is there a better way? Thank you for any help.

[pbaldy]

One way:

Minimum or Maximum Value Across Fields of Record