[AccessD] Determine Mileage Between 2 Zip Codes

Only 7?  Ours is somewhere around 12 miles.




"Marcus, Scott (GEAE, RHI Consulting)" <scott.marcus at ae.ge.com>
Sent by: accessd-bounces at databaseadvisors.com
04/09/2003 12:18 PM
Please respond to accessd

 
        To:     "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
        cc: 
        Subject:        RE: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030409/d4747c9f/attachment-0001.html>