zip code with x miles of another zip code

[Stephanie]

Hi, there. My db lists Members with their city, state and zip. Often a Member
will call the office and ask if there are other Members near them. If the
caller is from a large State we have to read the list of Cities and ask if
any are close to Member who is calling.

I'm wondering if anyone is using any programs where you can enter a zip code
and find another zip code within x miles. Is this program tied into your
Access db? I'd appreciate any suggestions to streamline finding Members who
are close to each other.

Thanks.

 

[orange]

Hi, there. My db lists Members with their city, state and zip. Often a Member
will call the office and ask if there are other Members near them. If the
caller is from a large State we have to read the list of Cities and ask if
any are close to Member who is calling.

I'm wondering if anyone is using any programs where you can enter a zip code
and find another zip code within x miles. Is this program tied into your
Access db? I'd appreciate any suggestions to streamline finding Members who
are close to each other.

Thanks.

I am on a list called AccessD. One of the popular contributors is John Colby who has posted such a database on the list. I'm sure it could be helpful to you.

Here is his message re the posting
"I have posted a fully functioning demo database for finding all of the zip codes within a radius."

http://www.databaseadvisors.com/downloads.asp

 

[Klatuu]

I would try googling for zip code databases. I haven't used one, but I do
remember seeing one that would do that, but I don't remember where.

 

[Gina Whipp]

Stephanie,

http://www.pcshareware.com/zipcodewiz.htm < seperate program works with zip
codes but not free.

I have one tied to an Access database but it only works with longitude and
latitude.