how to find lowest of two numbers in access 2000 query

[Umapathi36]

how to find lowest of two numbers in access 2000 query

 

[Ofer Cohen]

You can do that by using IIf

IIf([Field1] < [Field2],[Field1],[Field2])