If function help

[peterzou99]

I am trying to build a IIf function in my query (is it appropriate in query) to compare two fields A1 and A2 to get the lower value one.
can any one told me how to build it. i try MS help but it did not work out.

Thank you very much.

 

[RichO]

Yes, you can set up an expression field such as

=IIf([A1] < [A2], [A1], [A2])