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

[Bill]

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?

 

[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."