Re: How do you insert the fieldname of the lowest value?
3
1838
0
My issue is pretty simpel I think. How can I make a formula that checks for the lowest value in certain fields and inserts the name of the fieldname corresponding with the lowest value. Also, then, how can I insert the corresponding value in another field.
Kindly take notice of the two text fields in this example.
It just occurred to me you could change the formula used in the [Vendors] table’s primary field to something like
Vendor&' - '&'$'&Price&IF(FIND('.',Price&''),REPT('0',2-(LEN(Price&'')-FIND('.',Price&''))),'.00')&'/'&Unit
to get a little more information:
Edit: Fixed formula.
