How to save calculations

[bar891]

I'm a Newbie to access, I have a form that has mulitple text boxes with formula in them calculating from an input total. What i need to do is store the formula calculations so i can then calculate those answers to get to my totals. I read somewhere that you shouldn't store calculations, so i am confused. If someone has a better way of doing this or point me in the right direction.


Many Thanks

[June7]

The conventional wisdom is store raw data and do calculations in queries and reports. Result of a simple calc such as Quantity * Price doesn't need to be saved. There are situations when saving calculated results can be justified.

Total can be generated on calculated fields. Do an aggregate query using GROUP BY (Totals). Or do summary calcs in report header/footer sections. These are both basic Access functionality and Access Help has guidelines.

[bar891]

So i have some text boxes with formula in them that work correctly. How do i do a query on that text box?

[June7]

You don't. If the calculation is in textbox then it has a life only in the textbox. Alternative is to do calculation in query and bind textbox to the constructed field. Access Help has guidelines on how to do calculations in queries.

Also review http://allenbrowne.com/casu-14.html

[Rawb]

It depends on what kind of calculations you're doing. If all you're doing is very simple (grade-school) math, then check out my code here for a way to save calculations in a database.

This is very early code for me though, so it doesn't follow any order of precedence, it's strictly first-come first-served!

Example: 3 + 2 * 5 should equal 13. With the code I linked, it would come out to 25

[DepricatedZero]

You make PEMDAS sad Rawb :P

[Rawb]

Yeah, well he deserves to be sad after what he did to me in school!

On a side note, this post got me interested in saved equations again. After a little looking around, I think I've found some code that allows for advanced math to be processed from a string variable with proper precedence! I'll post here in a few with the code if I can get it to work!

[Rawb]

It works! Hooray!!!

Attached is a copy of the original source code along with a (slightly engrish) manual on the whole thing. Note that you need to import BOTH the .cls file and the .bas file into your database for it to work.