How do I save the data from a calculation.

xenos132

Registered User.
Local time
Today, 02:29
Joined
Jan 9, 2005
Messages
15
On my form I have calculated fields based on information from my sub forms. I have the calculations all working fine however I can seam to figure out how to save them in the table that my form is linked to as my control source is the calculation. Should I be using my calculations in an area other than the control source?
 
I don't know the purpose of your form, but here's a question for you to chew on...
If you can calculate the value, why would you want to store it?
 
Calculations

This is a topic that comes up frequently.
And the answer from the professionals (not me!) is always the same.
Don't store calculations in a table. It can easily lead to inaccuracies
and it also causes overhead.
Calculating can easily be done in queries and/or forms and reports.
 

Users who are viewing this thread

Back
Top Bottom