Advanced Math

M

Matthew Ellis

Is a query a good place for more advanced calculations than simple addition and multiplication? For example, I need to write a formula like:

([TotalOil] / [TotalWater]) * [IndividualWater]



(The formatting is how I would do the calculation on paper. I am not sure how to format that into a query or series of queries). Thanks, Any help is appreciated.
 
R

Rick B

You would do pretty much what you have on your screen. You have to tell it
waht to call the result though....

OilCalculatedResult: [TotalOil] / [TotalWater] * [IndividualWater]



Note: For multiplicaton and division, the parenthesis are not needed. the
results are the same if multiple first, or divide first. (Standard order of
operations - almost forgotten knowledge from high school algebra)



Rick B

Is a query a good place for more advanced calculations than simple addition
and multiplication? For example, I need to write a formula like:

([TotalOil] / [TotalWater]) * [IndividualWater]



(The formatting is how I would do the calculation on paper. I am not sure
how to format that into a query or series of queries). Thanks, Any help is
appreciated.
 
Top