Square Root Calculation in Access

Wizards,

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))

Result: 223.6

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?????

Please HELP!
Akkas  
AkkasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike EghtebasDatabase and Application DeveloperCommented:
Use:

=(((B2 GRID North-B1 GRID North)^2)+((B2 GRID East-B1 GRID East)^2))^0.5
0
Gustav BrockCIOCommented:
In Access it is called SQR():

=SQR(([B2 GRID North]-[B1 GRID North])^2+([B2 GRID East]-[B1 GRID East])^2)

/gustav
0
AkkasAuthor Commented:
eghtebas:
The formula works great in Excel, as an alternative. However this does not operate in Microsoft Access. Results are far from what is achieved in Excel.

Cactus Data:
The result of the expression in Access is far less then my original result in Excel. I was expecting a value of 223.6 & I got 141.421.

I have played with these statements but have not had much luck in modifying them to provide a spot on result.

More ideas and suggestions please!!!
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Gustav BrockCIOCommented:
From your own parameters:

? SQR((100600-100500)^2+(100700-100500)^2)
 223,606797749979

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AkkasAuthor Commented:
Gustav:
I was working late last night until 5am U.K. time, I picked up your statement and entered it incorrectly and kept on entering it in incorrectly..
I got it now..Thanks
Akkas
0
Gustav BrockCIOCommented:
Oh Boy. You better get a good night's sleep!

/gustav
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.