P
PJ
I have the following in a text box. I need to have the text box look at
three fields and return Exception Approval if Exception Approval is in any of
them or the lowest dollar amount. The below is working with one field.
=IIf([CmbRatingLQR].[Column](1)="Exception Approval","Exception
Approval",CCur(Val([CmbRatingLQR].[Column](1) & "")))
Field names
[cmbRatingMoodys].[column](1)
[cmbRatingSP].[column](1)
[cmbRatingLQR].[column](1)
three fields and return Exception Approval if Exception Approval is in any of
them or the lowest dollar amount. The below is working with one field.
=IIf([CmbRatingLQR].[Column](1)="Exception Approval","Exception
Approval",CCur(Val([CmbRatingLQR].[Column](1) & "")))
Field names
[cmbRatingMoodys].[column](1)
[cmbRatingSP].[column](1)
[cmbRatingLQR].[column](1)