Save a calculated field in a query back to a field in the table.

G

Guest

I have a form based on a query. The form uses table and query info to
calculate a final result for each record in the table. THis result is a
calculated field in the query.
I have a field made for the resultant in the table which I am trying to get
the form/query to save the calculated result back to the table as hard data.
My question is: How do I get access to save the final value in the
calculated field back to an actual "hard data" field in the table so I can
then do analysis of the many records with the new calculated data in the
table?
 
A

Al Campagna

Bill,
It is not advisable to save calculated values that can be derived from data you already
have saved.
Ex. Price * Qty = LineTotal
Since you capture Price and Qty, you can always re-derive the LineTotal "on the fly" in
any subsequent form, query, or report. Therefore it is uneccessary to save LineTotal to
the table.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

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

Changing sign of a value in calculated field 1
Calculated Field now Error 2
Need help on how to pass calculated field from a form to another form 0
calculated field in form - to table 2
saving auto calc data to the original table 3
Struggling with Calculated Field on Form to Main Form/Table 2
calculated field means not being able to change subform fields? 5
Saving a calculated field 8

Top