Data handling

[Erictsang]

Dear all



I have a question that confused me

a) I have a master file for sales and product
b) i have use this master file for query to filter the field that i can and do calculation , sales x qty
c) a calculation field is created
d) Am i right that i should not put that "calculated result back to the master?

e) it is not a good idea to put all fields created back to the Master

Eric

[JoeM]

That is correct. Anything that can easily be calculated "on-the-fly" should not be stored back to the master table.
Just leave it as a calculated field in a query.
There usually is no reason to store it back to the original table, as you can use a query for pretty much anything that you would use a table for (Exports, Forms, Reports, etc).
The one exception I see if if you have ever changing data, and want to capture its value at a particular point in time (historical archiving).