Access Form Calculation Question

J

John

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?
 
R

Rick B

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!
 
O

Ofer

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
 
J

John

Thanks Ofer, I will use a query. That way I wll probably live longer and
prosper.
Greetings from Tenerife
John
 
J

John

Thanks Rick,
Your advice is noted, although the tons are a bit overwhelming.
All of the best
john
 
Top