Hi,
In the Expression Builder of Control Source of a report text field, I want to set the field value to the lesser of a calculated amount and field value. How would I set that up as I don't see a VBA "Min" function that is applicable. Thanks.
Hi,
In the Expression Builder of Control Source of a report text field, I want to set the field value to the lesser of a calculated amount and field value. How would I set that up as I don't see a VBA "Min" function that is applicable. Thanks.
= IIF([FIeld1]<[FIeld2], [Field1], [FIeld2])
Glad to help!!