Conditional Value in report design?
Windows 8 
Access 2013
Hello everyone,
I am new and I am about to rip my hair out. I am a beginner with Access 2013 and I am currently taking a class on it. Unfortunately, it is an online class so the professor isn't always available to speak with.
I am a bit confused on a report I have to do and can't figure out the expression to use in report design. I will include screen sprints so that there is a better understanding of what it is I am trying to do.
In report design view, I have been told to create a sales prices. If the Base Cost is $10 or more, there is a 2% discount. If the Base Cost is less the $10 there is 1% discount. I used the expression =IIf([Base Cost]>10,0.02*[Base Cost],0.01*[Base Cost]). It calculates the expression and gives me the correct discount, but I need the sum after the discount has been calculate. SEE ATTACHMENTS!
As you can see on the first attachment, it shows the discount and not the sum! I am very confused with what to do, so if anyone can help me with the expression, I would be really happy! I know it sounds stupid, but I have been trying to figure this out on my own for awhile now before turning in the assignment! Ugh
Thank you!
Reply With Quote
Originally Posted by June7
