Advanced Math

  • Thread starter Thread starter Matthew Ellis
  • Start date Start date
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.
 
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.
 
Back
Top