[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

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
0
Patrick O'Dea
Asked:
Patrick O'Dea
1 Solution
 
danishaniCommented:
I cannot open the database, as it is problably made in Access 2010.
But you can try this in an Unbound field or in a Query;

Assuming the SpecialPriceUsedYN is a Y/N field;
=IIF([SpecialPriceUsedYN]=Yes,[SpecialPriceValue],[OrderValue])

HTH,
Daniel
0
 
Patrick O'DeaAuthor Commented:
Thanks Daniel,

Nice and easy !
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now