[AccessD] Distance between zip codes

[jack drawbridge]

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
>