Putting a Condition in A Report Layout
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".
Simple Question:
See yellow field on Report1.
How can I put the OrderValue in the YellowBox if "SPecialPriceUsedYN=N"
AND
How can I put the SpecialPriceValue in the YellowBox if "SPecialPriceUsedYN=N"
EEReport.accdb
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".
Simple Question:
See yellow field on Report1.
How can I put the OrderValue in the YellowBox if "SPecialPriceUsedYN=N"
AND
How can I put the SpecialPriceValue in the YellowBox if "SPecialPriceUsedYN=N"
EEReport.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nice and easy !