Calculations on Form bound to a field in a table

G

Guest

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?
 
R

RBear3

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top