Calculate Distance From Postcode to Base

[dvent]

Hi All,

I have a table in my database housing a number of locations (over 1100). I also have my base location e.g. SW1A 2AA

Is there anything I can add-on to access to calculate the distance between the static postcode and the postcodes found for all of my other locations?

Thanks in advance
dvent

 

[John Big Booty]

If you have Longitude and Latitude values for all your Postcodes it should be a simple exercise to calculate the straight line distance between any two point.

See this sample DB for an example.