How can I get a calculated value from my form into a field in the

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

Guest

I have created several calculated values in a subform and I was able to total
these on the main form. Now I want to move these totals from the main form
into a field in the database before I enter another record. Can anyone help
me?
 
I have created several calculated values in a subform and I was able to total
these on the main form. Now I want to move these totals from the main form
into a field in the database before I enter another record. Can anyone help
me?
Click to expand...

Sure.
Don't!
Storing calculated data is not necessary, and goes against the rules
of relational database design. Besides wasting memory space, it is
susceptible to error if one of the components of the calculation needs
to be changed.

As long as you have the various parts of the calculation saved,
whenever you need the total, re-calculate it, on a form, in a query,
or in a report.
 
Back
Top