Save form calc value to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,

Please help me determine how to save a calculated form value to its
appropriate place on a table? This seems rather remedial but I'm stumped.

Basically, I want the total of A+B+C on the form to show a running total on
the form and also have it save that total value to the "Amount" field of
Table1. Currently, I have the TextBox on the form with a ControlSource of
=A+B+C and that give me the running total but I cannot figure out how to have
that value saved to the table.

I appreciate your time in educating me on this.
Thanks in advance,
DK
 
You should not save a calculated value to the table. It is redundant. What
if "A" changes later? How will access know to change the "total"?

When you need that value in a report, form, or query, simply do what you did
here and perform the calculation.

Rick B
 
Thanks Rick.

I guess my thinking was "what if the user does not have A, B, or C and is
able to only input a total?" Then an amount would have to be saved.

You posts makes sense though and I think I can implement your suggestion for
my project. Any thoughts on my "what if" scenario?

Thanks again,
DK
 
DK said:
Thanks Rick.

I guess my thinking was "what if the user does not have A, B, or C and is
able to only input a total?" Then an amount would have to be saved.

You posts makes sense though and I think I can implement your suggestion for
my project. Any thoughts on my "what if" scenario?

Thanks again,
DK
Click to expand...
 
It is enough to know that the relational rules state that no value in the
database should be the result of a calculation on another value in the
database. Translation: calculate and display values but do NOT store them.
It's your application and you can do what you want. Just don't bother
posting questions that about how to corrupt databases. The children might
be watching and listening and it wouldn't be right to steer them wrong.

Do you really believe that Codd and Date sat around at IBM and tried to top
each other in taking away the freedoms of database application
evelopers? }:-)

HTH
 
Back
Top