Access Form Calculation Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used the build feature to do a simple calculation in the "control
source" of a field. Now I want to write this to a field in the underlaying
table, I have not been able to figure out how. Is it possible, is it wise?
 
You don't store a calculated value.

Please search and read the posts here before you post a new thread. There
are thousands of posts out here with tons of valuable information - Use It!!
:-)

Good Luck!
 
If you search this discussion group for the same question, about storing a
calculated field, you will always get the same answer, "Don't do it, its not
wise" , you'll need to maintain it, and it could cause alot of errors.
You can always achieve it using a query with calculated field

e.g
Select Field1, Field2, Field1 + Field2 As Field3 From TaleName
 
Thanks Ofer, I will use a query. That way I wll probably live longer and
prosper.
Greetings from Tenerife
John
 
Thanks Rick,
Your advice is noted, although the tons are a bit overwhelming.
All of the best
john
 
Back
Top