• 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."