[AccessD] Determine Mileage Between 2 Zip Codes

Chris

...there is a commercial AxtiveX component that gives you the mileage
between two zips.
http://www.scribblesoftware.com/zipratex.mv

William Hindman
"War is an ugly thing but not the ugliest of things; the decayed and
degraded state of moral and patriotic feelings which thinks that nothing is
worth war is much worse. A man who has nothing for which he is willing to
fight, nothing which is more important than his own personal safety, is a
miserable creature and has no chance of being free unless made and kept so
by the exertions of better men than himself."  John Stuart Mill

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


> Scott,
>
> In DC there are no zip codes that are very large so using it as an
> approximation is an acceptable method and was specified by the contract, I
> just need to know if there's an automated way to do it.  If I can get
access
> to a system that uses the full address then that would be even better, but
> it doesn't need to be that percise.
>
> Chris Mackin
> www.denverdb.com
> Denver Database Consulting, LLC
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Marcus, Scott
> (GEAE, RHI Consulting)
> Sent: Wednesday, April 09, 2003 11:18 AM
> To: 'accessd at databaseadvisors.com'
> 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
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>