I've got a data structure that has three monetary fields. The first is Netto (German for net value), Steuer (Tax) and then Brutto-- representing net value minus the tax. The calculation rules are:
Netto (manually entered)
Steuer = Netto-(Netto/1.16)
Brutto = Netto-Steuer
A typical (and correct) calculation would be:
Netto = 116.00
Steuer = 16.00
Brutto = 100.00
My problem is that after manually entering the netto value, the steuer value is correct, but the Brutto is incorrect. It seems that somehow it is picking up previous values of the Netto field.
For example, if I enter a completely new record, the values are, respectively, 116, 16 and 116 after I manually enter Netto. The last value should be 100. If, however, I go to a previous record, or I add a new one, the value Brutto is updated correctly.
This outcome is the same whether I am using a table (browse) or form to enter the data.
My question: if the second field (calculation field) is calculating correctly upon my manual data entry, why isn't the last field calculating correctly?
My only hunch on this is that the last calculation field happens to be the very last field of the form, and this may be "causing" the problem.
What can I do to ensure that the value I'm getting is automatically correct (and calculated) when the first value is manually entered--without having to procede to a new or previous record?
-- John
Netto (manually entered)
Steuer = Netto-(Netto/1.16)
Brutto = Netto-Steuer
A typical (and correct) calculation would be:
Netto = 116.00
Steuer = 16.00
Brutto = 100.00
My problem is that after manually entering the netto value, the steuer value is correct, but the Brutto is incorrect. It seems that somehow it is picking up previous values of the Netto field.
For example, if I enter a completely new record, the values are, respectively, 116, 16 and 116 after I manually enter Netto. The last value should be 100. If, however, I go to a previous record, or I add a new one, the value Brutto is updated correctly.
This outcome is the same whether I am using a table (browse) or form to enter the data.
My question: if the second field (calculation field) is calculating correctly upon my manual data entry, why isn't the last field calculating correctly?
My only hunch on this is that the last calculation field happens to be the very last field of the form, and this may be "causing" the problem.
What can I do to ensure that the value I'm getting is automatically correct (and calculated) when the first value is manually entered--without having to procede to a new or previous record?
-- John
Comment