[AccessD] Distance between zip codes

Rocky Smolin rockysmolin at bchacc.com
Tue May 23 08:37:23 CDT 2017


OK - thanks.  I found a couple zip/lat/long files and some code that
calculates distance.  Don't know how accurate it is but it looks good.

R


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

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



More information about the AccessD mailing list