Radius Search????

D

Doctor

I am trying to find all records, say, within 100 miles of a zip code. Can
anyone point me in the right direction? I've spent hours looking around on
the web. I've found a lot of distance searches, but nothing that find all
records that meet the criteria.

Please help!

Thanks in advance
 
D

Doctor

Karl,

Thanks again for pointing me in the right direction. When I saw the website,
I thought it was the answer to my problems.

BUT after I purchased the software, I discovered that there is no help or
support whatsoever. I've called and emailed. No replies.

Would you be willing to help me put all of their code in the right place in
my file? I have no idea where it is all supposed to go. Their read me file
lacks a lot.

Do you happen to have a sample database you could send my way. I could
probably figure it out just from seeing someone else's code.

Thanks,
 
G

gdaniels

I am trying to find all records, say, within 100 miles of a zip code. Can
anyone point me in the right direction? I've spent hours looking around on
the web. I've found a lot of distance searches, but nothing that find all
records that meet the criteria.

Please help!

Thanks in advance

Hi. I was successful in making a radius search for records in an
Access Database. Instead of Zip Codes, it uses a specific property
address, or rather its longitude and latitude, as the centroid. All
records are geocoded with latitude and longitude. The geocoding is
quickly done through a free batch geocoding website. When a radius
search is done in my database, the matching records are returned based
on a formula that computes the distance of each record from the
centroid. If you think this is something you could use, let me know
and I'll provide you with the details and code.

Gary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top