Tesiny, Ed
EdTesiny at oasas.state.ny.us
Wed Apr 9 12:45:34 CDT 2003
Chris, Take a look at www.zipfind.net Ed Tesiny EdTesiny at oasas.state.ny.us -----Original Message----- From: Marcus, Scott (GEAE, RHI Consulting) [mailto:scott.marcus at ae.ge.com] Sent: Wednesday, April 09, 2003 1:35 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Determine Mileage Between 2 Zip Codes So 2 zip codes next to each other are zero miles appart but could total more than 7 miles. Even worse, 3 zipcodes could touch each other and each be zero miles appart. I think address is gonna be the only way. Scott -----Original Message----- From: Chris Mackin [mailto:chris at denverdb.com] Sent: Wednesday, April 09, 2003 1:29 PM To: accessd at databaseadvisors.com 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com