Hi every one:
I have query based on “Items in shop” table containing a “Client’s price” field for each item. This query calculates several percentages based on the “Client’s price” field.
Second Hand items Shop
This a 5% on the client items price to keep the item at the shop
Ad fee 5%: [Client's price]*0.05
Then I have a form with “Control Source” the mentioned Query with the following fields:
Client’s price:
Ad fee 5%:
The calculation is working perfect, every time you change the value from “Client’s price” calculates the 5% perfectly.
The Issue:
I want the expression in the query to set the percentage to be set to 0% if the “Client’s price” value is under 20. Only calculate the percentage if the “Client’s price” value is over 20.
Thank you very much for your help.