Access Query: Calculate lowest value field

[andreys]

SELECT Field1, Field2, Field3, 
IIf([Field1]<[Field2] And [Field1]<[Field3],[Field1],IIf([Field2]<[Field1] And [Field2]<[Field3],[Field2],[Field3])) AS MinValue 
FROM TableName