K
kateoc
I have a calculated control on a form with the control source
expression:
=(contractprice([yield],[r1],[p1],[r2],[p2)*[area] (where r1, p1, r2,
p2, yield and area are entered into the form).
I want it to calculate the contract value where there are two levels
of price for the first 6 tonnes/ha the price is p1 and the for the
next X tonnes it is at a price p2.
I change the above expression (as it doesn't give the right answer) to
=contractprice(([r1]*[p1])+ (([yield]-[r1])*p2)*[area]
But I have two problems, as soon as I close the properties on the box
the expression goes back to the original expression.
Why can't I change it?
What is wrong with my edited expression?
What does the orignal 'expression' do anyway?
thanks in advance for any clues it is driving me wild.
Kate
expression:
=(contractprice([yield],[r1],[p1],[r2],[p2)*[area] (where r1, p1, r2,
p2, yield and area are entered into the form).
I want it to calculate the contract value where there are two levels
of price for the first 6 tonnes/ha the price is p1 and the for the
next X tonnes it is at a price p2.
I change the above expression (as it doesn't give the right answer) to
=contractprice(([r1]*[p1])+ (([yield]-[r1])*p2)*[area]
But I have two problems, as soon as I close the properties on the box
the expression goes back to the original expression.
Why can't I change it?
What is wrong with my edited expression?
What does the orignal 'expression' do anyway?
thanks in advance for any clues it is driving me wild.
Kate