Calculate Values in a table

  • Thread starter Thread starter FD
  • Start date Start date
F

FD

I am looking to batch calculate and populate the values for a whole column
based off another column. I need to calculate record 1 in column 2 by
subtracting record 2 that is in cloumn 3 from record 1 that is in column 3.
Is this possible?
 
You should not be storing calculated data. If the fields exist to generate
the calculated data then you should just display the calculated field in a
query for display, or further calculations. Storing calculated data can
result in data integrity issues, as well as violating normalization rules.

There are ways if you absolutely have to, but this is very rare to have to
really store it. You would use an update query to do it if you had to.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________
 
I can do it in MS Excel and copy and paste the records back in the table in
access, but I am looking to avoid that step if possible.
 
Back
Top