If the numbers that make up the calculation are already in the table, then
you don't need to also store the total. It is redundant. When you need the
calculated value, just calculate it. It is more efficient and you don't
have to worry about changing the total if you go in and change one of the
values that is included in that total.
Database normalization rules would say that you don't store calculated data
in a table.
--
Hope that helps!
RBear3
..
"WildlyHarry" <(E-Mail Removed)> wrote in message
news:E523483E-E505-4455-BA8D-(E-Mail Removed)...
> Is possible to perform calculations in a field and have them stored in a
> table? For instance I have a call log form where users enter different
> types
> of calls that they recieve. the fields that they enter are bound to a
> table
> that tracks the calls. I can place formulas in the form that display the
> totals of the different calls. Can I have those totals bound to a field
> in
> my table?
|