What is wrong with this equation?

[rclark1]

Hi all,

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)
TABLE:| <Table

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

=SQRT((C8-A8)^2+(D8-B8)^2)

Thanks

[meratigoerr]

Hi all,

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)
TABLE:| <Table

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

=SQRT((C8-A8)^2+(D8-B8)^2)

Thanks

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?