I am trying to calculate the distance between two points/buildings using Grid Reference's, heres what I have in Excel
Building 1 (B1)
B1 GRID North = 100500
B1 GRID East = 100500
Building 2 (B2)
B2 GRID North = 100600
B2 GRID East = 100700
=SQRT(((B2 GRID North-B1 GRID North)^2)+((B2 GRID East-B1 GRID East)^2))
Now I have tried using the same formula in an Access Select Query but can not use the same function SQRT, it does not exist? When I run the Quesry I get the message "Undefined function "SQRT" in expression".
If I use the SQR function this give me a higher value, I am not sure what to do?????