Form Calculations

[Guest]

I have a form with a few fields that are calculations of other fields on the
form. How do I store these calculations on their own fields on the table? I
have the calcualtions in the 'Control Source' field on the text box and that
is usually where the field name goes. Any help would be great. Thanks.

 

[molsonexpert]

Your question is asked almost on a daily basis around here.

Why do you want to store the calc in a table? It seems to be working fine as
is. If the fields that make up the calc are already bound to a table,
there's no reason to store the calc itself in the table.

 

[Guest]

The normal thing is NOT to store calculations but just repeat the process
every time the data is needed. When the information the calculation is based
on the the results are not longer accurate.
About the only time you would want to store calculations is when you would
also put a datetime tag with it to indicate when the calculation was correct.
This could be when an item was sold as the price could be changing often.
What is your situation?

 

[Guest]

Should I just store the calc in the form and if I need the calc in a report,
create the calculation again for the report??

 

[molsonexpert]

Sure. It really is easier to create a calculation on an unbound control on a
form or report, than to try to store it in a table. If you were to store it,
there are many scenarios where, if the data was changed, that the
calculation might not get updated, and then you're left with incorrect
calculations.