I have a question about Access database. I'm creating a form. I have a retail price that I want to get a 5% discount from to make a sale price. The sale price is the retail price - the discount but I cannot figure it out. I have been trying this but it does not give me what I want in express builder.
=IIf([Retail Price]>20,0.05*[retail price],0.02*[sale price])
I've tried many different combinations but can't get it.