hi,

ffulmer via AccessMonster.com wrote:
The new queries will change the old invoices by recalculating them. And that
should not happen.
I am sure it is a very common problem and must be a solution for that.
Does any one have suggestion what way to go? or other possible solution?
Despite the fact, that you shouldn't store data which can be calculated,
storing invoices is a must. Otherwise you never can guarantee that the
old invoices will be correct. As this is what happens in your case.

Step 1:
Create a table (structure) for storing your invoices with the dependent
data.
Store the old invoices.
New invoices will be stored when being issued to the customer.
Basically the point when to store it, is when this invoice becomes tax
relevant.

http://en.wikipedia.org/wiki/General...ing_Principles


Step 2:
Change your calculation.


mfG
-- stefan --