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.
Calculation if Statement (1 Viewer)
- Thread starter sandylt
- Start date
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:
This will calculate the final price dependent on the total score percentage and you can include this figure in your reports.
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:
Code:
FinalPrice: IIf([TotalScore]<0.9,[ContPrice]*[TotalScore],[ContPrice])This will calculate the final price dependent on the total score percentage and you can include this figure in your reports.
R
Rich
Guest
should be
=IIf([TotalScore]<0.9,[ContPrice]*[TotalScore],[ContPrice])
=IIf([TotalScore]<0.9,[ContPrice]*[TotalScore],[ContPrice])
Similar threads
Solved
Invalid use of Null