Calculate Miles

[rbiggs]

Is there an add in or third party application that integrates well with access that will calc the distance between 2 addresses? I have briefly looked at longitude and latitude but that is really just a straight line and I was looking from something more accurate.



Thanks

[orange]

Please describe your situation more completely. What exactly do you mean miles between 2 addresses? With addresses you can have ZIP codes which represent an area locator, or a physical set of Lat/Log coordinates which represent a point locator.

What are you trying to accomplish?

You might want to read up on Great Circle Distances in VBA here
http://www.cpearson.com/excel/LatLong.aspx

[rbiggs]

I have a database for a trucking company the dispatchers enter a address for a pickup location and then several drop off locations. The drivers are paid for the miles related to the particular part of the route. So a route could have different drivers. I wanted to calc the distance of between the pickup location and the first drop off then the first drop off and 2nd drop off and so on. I will read that link you had posted. Thank you for your help.

[orange]

Another thought that may apply -- and I must advise that I have NOT tried this-- is the possible use of Google maps. You can find the distance between locations from Google maps, but I'm not sure how exactly to do it using code.
Perhaps someone on the forum has experience in this area and could advise,

Good luck.

[rbiggs]

I was wondering if anyone has used the built in web browsing in access to do this. I can figure out how to pass addresses to a webpage I don't know how to get the webpage to return a value to the database though.