Saving Calculatons to a Table

[Benjamin Bolduc]

Im making a form for my DB at work that needs a lot of calculated fields. So I write the calculation as the control and it works fine, but none of the numbers are being stored in there respective tables and I need them to be for analysis purposes later. Is there anyway to save these calculations?

 

[Chris RR]

Don't do it. A basic rule of database design is to not save anything that you can recalculate from the record. I KNOW it sounds like a great idea, but the answer is still don't do it.

What will happen if you store a calc, and then the user goes into the record and changes the value of one of the variables that made up that calculation? (What would happen in my shop is that the user would blame me for the bad calc.)

You could save your self some work, and make things much easier to maintain later, if you set up your more complex calculations as user-defined functions. Then call these functions in your queries...

[This message has been edited by Chris RR (edited 01-31-2002).]

 

[Haytham]

Saving calculations in tables will load your db which advised to avoid it.
Still you can do it by creating a make-table query and update your data to a new table.
I fully agree to avoid such headache.

 

[Benjamin Bolduc]

Thanks for the warning, I definatly wont do that then.