Calculating distance in access?

[CarolR]

Hi everyone. Before I design an application in Access, I need to know if a certain task is even possible. I have a table of Physicians containing their names and addresses. What I would like to accomplish is to be able to provide an entry screen that would allow a user to input their zip code and have Access search for the physicians with a 1) 5 mile radius 2) 10 mile radius, etc. Is this even possible within Access?

Thank you.

I might add I'm an average Access user - no VBA experience, but will be learning.

[June7]

This would require a table of records pairing each physician address with every possible user address and the distance between the two. Impractical to the point of impossible. Geospatial proximity analysis is a function of software like ESRI ArcGIS (cost is thousands) and MS MapPoint ($299) and online mapping like Google Earth, Google Map.

Might be able to incorporate Google Maps into a web control on form and do interactive search on the map.

[orange]

I created and recently updated a sample database for this type of request. Please see post 38 at http://www.access-programmers.co.uk/...d.php?t=225339 for the latest database.

You will gain some insight by reviewing all the posts in the thread.
Post back if you have questions.