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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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."
 
Back
Top