Finding out the MIN value between multiple fields

[Yazster]

I have 6 fields:
FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6

I want to run an UPDATE query and place into FIELD6 the smalled value between the 5 first fields. The MIN function only accepts one field and returns the smalled number in one field. How would I compare multiple fields in the same record and extract the smallest value?

Any help would be greatly appreciated.

Thanks,
Yazster.

 

[JohnYingling]

lngMin = field1
if field2 < lngMin then lngMin = field2
if field3 < lngMin then lngMin = field4
etc

http://WWW.VBCompare.Com