January 7th, 2013, 08:37 PM
What is wrong with this equation?
I am trying to use a query to calculate the value of field in table. This is the equation that i came up with
FIELD:| <FieldToBeCalualted>: Sqr(([Field1]-[Field2])^2+([Field3]-[Field3])^2)
but when i try to run the query it throws back "Extra ) in query expression"
What am i missing?
here is the equation in excel that i am trying to copy
January 8th, 2013, 06:43 AM
I don't see anything missing copied into a test DB your equation works fine, but Field3 - Field3 squared will always be zero. Can you copy and paste the whole SQL statement you are using?
Originally Posted by rclark1
Last edited by meratigoerr; January 8th, 2013 at 06:47 AM.