store the values of a calulated field for later use

[Guest]

All of my calculated fields are working properly, however I need to keep
these values in the table for analysis later on. I can't figure out a way of
doing this.

 

[Van T. Dinh]

Generally, storing calculated values violates the Relational Database Design
Principles and therefore, Access doesn't provide easy-to-implement method to
do this (it is still possible). The problem is that the stored calculated
value will be incorrect / inconsistent as soon as a component value (used in
the calculations) is changed. Hence, it is always better (except for
historical data) that the calculated value is calculated when required since
this is accurate and up-to-date rather than retrieving the stored calculated
value.