Quite right, Haversine it is. When I wrote this though accuracy is what I had in mind because of the type of application it was powering and the data we were getting was extremely accurate, or so the client claimed (without a GPS who am I to say it was not accurate!) since they were paying an astronomical amount of money for this and other GeoSpatial data.

I agree that the Pythagorean theroem is the way to go if accuracy is not of the utmost importance and, as you said, it is less resource intenstive.

As with anything in programming there is more then one way to solve a problem and I think that both solutions presented here achieve that with varying pros and cons.

-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

*** FULL DEMO NOW AVAILABLE ***

The full demo of my zip code locator that also maps found zip codes on a Google Map is now available.

Just go to the URL
    http://www.ClearviewDesign.com/Newbie
and then click on "demos".

You'll see this demo listed as the first and newest one on that page.

You can click on the link to try the demo or you can download a ".zip" file with all the needed content, including a SAMPLE database.

There is a "README.txt" file in the zipped directory that tells you how to obtain a fully functional database and how to modify it to make queries via the web page faster.

I'm not claiming this is commercial quality software. It is *MEANT* as a demo, and that's all it is. A better database and better human interface are left as an exercise to the reader.

Bill Wilkinson
The Old Pedant

I liked Old Pendant's solution and will try and modify that for my Infopath forms but if anyone has already created a solution in VB that works with a button control

I realize this is a rather dry vine but if there is anyone out there that could help it would make the world a better place.

Appreciate it,
Jeff