IIF statement to compare data in two columns

[ecalvert]

I have two columns of data...both numeric fields. I want to write an iif statement that returns the lesser of the two values in a third column...and on top of that, some of the fields might not have a value..in that case, the other column that has a number fills in the third...



please help, any would be appreciated.

[JoeM]

Assuming none of your values are greater than 999999999, then this calculated field should work:

Lesser:IIF(NZ([Field1],999999999)<NZ([Field2],999999999),[Field1],[Field2])

[ecalvert]

thank you very much JoeM...worked like a charm.