I have a form for evaluating our cleaning service. If the services total score is below 90% then it only gets that percentage of payment. If it is any where in the 90% range then they get full price. Is there any way to write an if statement saying If <90% then ContPrice * Percent, If >= 90% Normal.
Firstly you should not be storing this calculation in your table as it can be created on the fly in a query and output to your report.
The only values that you need to store are [TotalScore] and [ContPrice] where TotalScore is numeric type (single) and ContPrice is set to currency. TotalScore will be a value between 0 and 1 as it should be the percentage returned by your service evaluation.
In your query you will need a calculated field such as:
Im not storing it in a table it on my form. The Scores are calculated on the form. Do I add this statement to the control source? I tried it and it gave me an error.