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.
 

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

storing calculated values from forms into a database file 1
Calculate total in a form 1
Calculated Fields/Subforms... 7
Enter Parameter Value in Access Form 0
Access Daily Entry with multiple entries per field 0
How to calculate 3 fields of one record in a form 1
calculated control event order 2
Calculation In A Form For The New Guy 4

Back
Top