[AccessD] Distance between zip codes

[Stuart McLachlan]

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
>