[AccessD] Determine Mileage Between 2 Zip Codes

Chris,

Where I live, a zipcode can cover more than a 7 mile radius. I live in the
Greater Cincinnati area. By no means would you call where I live sparse in
population. How would you determine the difference between a zip code any way?
It would have to be by address. Maybe you could automate "MapQuest" to get the
distance between the office and client.

Scott

-----Original Message-----
From: Chris Mackin [mailto:chris at denverdb.com]
Sent: Wednesday, April 09, 2003 1:05 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Determine Mileage Between 2 Zip Codes


Does anyone know of any code or software that I can use to try and get
mileage between 2 zip codes?  The situation is this, in an insurance
database there is a contractual obligation for my client to report on the
number of members of the plan who live within 7 miles of one of the
providers of the plan.  There are about 250 providers in the Washington DC
area and approximately 15,000 members so the more automation I can get in
this the better.

Thanks,
Chris Mackin
www.denverdb.com
Denver Database Consulting, LLC



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com