Calculations on Form bound to a field in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WildlyHarry - 31 May 2007 21:44 GMT

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?

Reply to this Message

RBear3 - 31 May 2007 21:57 GMT

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.

Signature

Hope that helps!

RBear3
.

> 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
[quoted text clipped - 5 lines]
> in
> my table?

Reply to this Message