Click on "Report1" based on tblCustomers.
I have customers who buy things. The full non-discounted price of the Sales Order goes into "OrderValue".
If they are very nice to me (!) I set the SpecialPriceUsedYN flag to "Y" and enter an overriding price in the field SpecialPriceValue.
Therefore in tblCustomers there can be 2 values "OrderValue" AND "SpecialPriceValue".
See yellow field on Report1.
How can I put the OrderValue in the YellowBox if "SPecialPriceUsedYN=N"
How can I put the SpecialPriceValue in the YellowBox if "SPecialPriceUsedYN=N"