[AccessD] Distance between zip codes

[Kaup, Chester]

Here is something else you might look at

https://www.zipcodesoft.com/distance-between-zip-codes

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jack drawbridge
Sent: Tuesday, May 23, 2017 7:53 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Distance between zip codes

[This email message was received from the Internet and came from outside of Kinder Morgan]


Rocky,

There is a sample database (mdb format) at
https://access-programmers.co.uk/forums/showpost.php?p=1382593&postcount=65

that demos the use of 2 zips. 2 addresses, 2 lat/Long or any combination to find distance between them.
As others have said, I don't know of anything you can just drop in.

jack

On Tue, May 23, 2017 at 8:40 AM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Don't know of anything you can drop in, but here's a list of zip codes 
> with lat/lon.
>
> I've got some code that calculates distance between any two lat/lon 
> locations. (I wrote it for
> sailing)
>
> It would be fairly easy to write a  procedure thatsteps through the 
> data and locates matching codes, but it probably won't be very fast.
>
> Interesting project. Give me a day or so and I'll see f I can come up 
> with something  :)
>
>
>
>
>
> On 23 May 2017 at 4:37, Rocky Smolin wrote:
>
> > Dear List:
> >
> >
> >
> > I have a client who wants to know all of the zip codes that lie 
> > within a certain radius of a selected zip code.
> >
> >
> >
> > I seem to recall some discussion about this on the list but it could 
> > have been 15 years ago now.
> >
> >
> >
> > Is there some tool available that can be dropped into and Access FE 
> > (using 2010 now).
> >
> >
> >
> > MTIA
> >
> >
> >
> >
> >
> > Rocky Smolin
> >
> > Beach Access Software
> >
> > 760-683-5777
> >
> >  <http://www.bchacc.com> www.bchacc.com
> >
> >  <http://www.e-z-mrp.com> www.e-z-mrp.com
> >
> > Skype: rocky.smolin
> >
> >
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com