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