miletracker
Technical User
What is the easiest way to save the results of expressions in forms to the underlying table ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Saving form data ?
- Thread starter miletracker
- Start date
- Status
gusbrunston
Programmer
Hi, miletracker:
Sounds like you want to save calculated values in tables. This is a no-no according to the rules of normalization. Each time the value needs to be displayed, printed or used in another calculation, it should be recalculated. The rationale: if a value which is a factor in the calculation is changed subsequent to the calculation stored, the table would contain inaccurate information.
Don't shoot the messenger.
Gus Brunston
An old PICKer, using Access2000. I manage Suggestions welcome. padregus@attbi.com
Sounds like you want to save calculated values in tables. This is a no-no according to the rules of normalization. Each time the value needs to be displayed, printed or used in another calculation, it should be recalculated. The rationale: if a value which is a factor in the calculation is changed subsequent to the calculation stored, the table would contain inaccurate information.
Code:
B is always A - 10. Therefore, if
A = 700, then B = 690
But if A is changed to 750, then
B should be 740.
If 690 is stored as the value of B,
then the value of B is inaccurate.Don't shoot the messenger.
Gus Brunston
An old PICKer, using Access2000. I manage Suggestions welcome. padregus@attbi.com- Thread starter
- #3
miletracker
Technical User
Hi Gus thanks for the quick reply
miletracker
miletracker
- Status
Similar threads
