It is possible but the Relational Database Design Theory generally prohibits
storing calculated values in the Table since there are problems, most
notably inconsistencies, when you store calculated values since you have "to
remember" to update the calculated values when the constituent values are
changed.
It should be noted that re-calculation (in fast memory) is generally faster
than retrieving the calculated value from (slow) hard-disk.
There are exceptions, mostly to store historical data, i.e. updates of
constituent values are unlikely.
I would suggest you should find out about the Relational Database Design
Theory and the Database Normalisation technique first and decide whether you
should / need to store calculated values in your Table(s).
--
HTH
Van T. Dinh
MVP (Access)
RAB said:
I did a calculaltion in a query and used the query in a form. I want to
retain that calculation in a field. Is there some way to do that rather than
to repeat the calculaltion in a entry field for retention by hand?
