thanks tracy
>>To determine approximate distance between clients and employees, the need to calculate this knowing the latitude and longitude coordinates of our clients and employees.
>>
>>Used the routine that Craig Boyd has to find Latitude and Longitude from "geocoder" for all of our clients and employees and was successful for about 85% of the 8400 address locations we have. I am assuming that the address information for those 15% is not being recognized because of user putting such things as Box numbers, Apt. numbers etc.
>>
>>So i thought for these, that I could simply get an approximate Lat and Long based only on the Town name with out an address. However, this does not work.
>>
>>Does anyone have suggestions on how one can get the Lat and Long for each town with out an address?
>>
>>Thanks in advance.
>
>I don't know of a tool, but I know the FCC website does it. You can modify the city and state in this url and get the latitude and longitude:
>
>
http://www.fcc.gov/cgi-bin/atlas?city=FAYETTEVILLE&state=NC