Software

Ask something
Discussion Locked

Enter Zip code to locate nearest store

0 helpful
2 replies

by natnat

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am wondering how sites have a input for customers to enter their zip code and it shows the nearest location of the company. Can this be done easily or is their a package I can buy?

2 replies

by harley

You can do this yourself if you have a zipcode table with latitude and longitude. I found the distance formula on the web and plugged it into my access database query. It is surprisingly accurate!

It comes in handy when a client wants to findsay, a store within x miles from a given location.

Or I had to create a business rule to help decide if travel expenses should have been entered in the database. The user can check "No Travel Expenses". And they were doing this even if the distance of travel was from CA to NY! I put an end to that nonsense!

by gdaniels57

I'm looking to do the same as you described in your post, to create a search based on radius from a starting point using geocoded latitude and longitude. I've have the formula, but am stuck on how to apply it in Access. Thanks for your help.

Gary

This discussion is closed to new replies.