Calculate distance between two addresses

[JoeyB_99]

I am using Access 2010 and am developing a form where the user provides a full address - street number, street name, city, province and postal code.

I want a control to calculate the distance from this address and a fixed address.

I'm not sure where to start.

Any input would be greatly appreciated.

 

[Privateer]

I don't have a working answer for you but I think you need two things to get you started. You need the latitude and longitude for each address and you need the formula to calculate the great circle route distance. That is assuming you don't mean driving distance. I downloaded the formula in a spreadsheet macro but I haven't studied it or transfered it to Access yet. You might be able to download a zip code table with Lat/Long included and you could run a query based on the zip codes and get two coordinates and run the formula. Not as exact as an address but the postal service in the US is charging now for zip plus four, (house specific) tables. That's all I got.

 

[JoeyB_99]

Thanks Privateer for the quick and thorough response.

Unfortunately I do require the driving distance between the two addresses. But you have given me something to work with so I will start with your suggestion on prerequisites.

Thanks again.