Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Save Data from a Calculated Control to a table

Status
Not open for further replies.

kramsey

Technical User
Jan 16, 2003
5
US
I have created a calculated control in a form which gives me the total of items purchased. How do I send the total to the underlying table to be saved?
 
Ramsey - Same problem. Did you ever get (or find) an answer?

Thanks,

Penn
 
More info:

Question:
"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?"

Answer:
"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."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top