Access Validation Formulas

[Dan T]

Hi There.

Now i know you are unable to enter excel formulas into access.

I am trying to create a calculated result into a cell on a table.

FilterID	FilterPartNumber	CostPrice	RRP	SellPrice
1	Z543	$54	$86

In the SellPrice Column, Id like to be able to perform the following calculation.

IIf([RRP]*0.9>[CostPrice]*1.2,[RRP]*0.9,[CostPrice]*1.2)

Essentially, I try give all my customers 10% discount off Recommended Retail Price (RRP), But i do not want to give them the discount if it is cutting into my 20% profit.

Thank you in advance for your assistance.

[CJ_London]

as you have written it, the formula should work. However calculated fields in tables is generally not a good idea and in this instance could create problems down the line. What you should be doing is calculating in a query and store the actual value, not the calculation. Why? because down the line, business gets better and you want to give customers 15% discount if you can (rather than 10%) - result would be all your previous transactions will change.