FargoUT, you're making me realize that perhaps what Caruncles is looking for requires a little more info.
If you don't have geocoding software to turn addresses into lat/long, then it might be a little stickier, but you can get that data online too, http://stevemorse.org/jcal/latlonbatch.html being a good example of that.
Then use Barry's function (or use it inline if you want) to get the distance between two addresses.
**Edit (oops, Caruncles, not Carbuncles lol)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."