Not Access related q. Find distance between two ZIPs

[Galsaba]

I am trying to find a software that can find distance between two ZIP codes.
I think most of them do it by having the longtitude and latidute of each ZIP,
and substract. But this gives the air distance. Where can I find software that
find the ground distance (like in Mapquest).

Thanks,

Joe

 

[PC Datasheet]

Joe,

I don't think you will find what you are looking for!

Zipcodes encompass an area; they are not specific points. Imagine zipcode area 1
with zipcode area 2 next to it on the east side. A point on the east border of
zipcode area 1 would be 0 miles from an adjacent point on the west border of
zipcode area 2. A point on the west border of zipcode area 1 would be many miles
from a point on the east border of zipcode area 2. The distance between zipcode
1 and zipcode 2 is therefore anything from 0 to many miles!

 

[Galsaba]

OK, OK then not distance between two zipcodes, but distance between two
addresses. That's waht I am looking 4.

Joe

 

[John Vinson]

OK, OK then not distance between two zipcodes, but distance between two
addresses. That's waht I am looking 4.

Unless you have accurate latitudes and longitudes for all the
addresses you'll ever need, *and* an accurate and up to date digital
road map of the entire area you wish to cover, this isn't going to be
possible. And the latter need (I would suggest) takes the problem
outside the range of applications which Access would be able to
handle!

 

[PC Datasheet]

Take a look at Microsoft MapPoint - it does what you want to some degree. See if
it's adequate for your needs.

 

[John Nurick]

Try MapPoint.

I am trying to find a software that can find distance between two ZIP codes.
I think most of them do it by having the longtitude and latidute of each ZIP,
and substract. But this gives the air distance. Where can I find software that
find the ground distance (like in Mapquest).

Thanks,

Joe