Saving calculated data on form textbox to a field in a table

Faction21

Registered User.
Local time
Today, 14:29
Joined
Oct 26, 2004
Messages
42
How would i go about saving the data in a calculated textbox on a form into a field in a table?

For example, on the form there is =[MatchedPages]+[UnmatchedPages] that I put into a textbox. I now want to store those results in a table with the field titled TotalPages. How would I do this?
 
Calculate

It is a good rule not to store calculated data in a table.
It needlessly takes up space and in some cases may cause invalid results.

Calculated data can be generated anytime on forms, reports and in queries.
This question has come up many times in this forum, and the answer (from the profesionals) is always the same.
 
hmmm.. well the calculated data i needed to store would never change, and we need to keep record of it, so that if we need to go back and look at the data we dont have to recalculate the same values.
 

Users who are viewing this thread

Back
Top Bottom