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?
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?
Microsoft Access
Last Comment
PatHartman
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
You both posted the same solution 7 minutes apart. And it works!
Jeff types faster:)
ASKER
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.