Link to home
Create AccountLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Calculte distance between two points

If I have a table with Locations, Latitude, and Longitude, is there a way with MS Access to calculate the distance between them?

I'd have a form with two comboboxes.  The user would select two different locations in those comboboxes.  Then in a text box on the form would be the distance between them.

Possible?
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of SteveL13

ASKER

You both posted the same solution 7 minutes apart.  And it works!
Jeff types faster:)
Unsure of the rules.  Do I award to both of you or the first one?  I'm not sure I've ever had exactly the same solution so close to one another.
I think the posting order is somewhat out of our control so on any given day, I could have ended up first.  There is no hard rule but if we each posted the same answer minutes apart I would be OK with splitting the points were I in first but awarding all the points to Jeff isn't a problem for me either since technically he beat me.