Access Query: Calculate lowest value field

[jamesbrown]

Hi.

I have a query with 3 fields that will contain a numerical value. I want to add another calculated field that looks at the 3 fields and returns the value of the field with the lowest number.

So:

Field1: 25
Field2: 16
Filed3: 21

CalculatedField: 16

Anyone know the formula I would put into the calculated field.

Thanks a lot

James Brown

[andreys]

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

[jamesbrown]

Thanks andreys, worked a treat.

Thanks for your help.

James