Link to home
Start Free TrialLog in
Avatar of TOPIO
TOPIOFlag for United States of America

asked on

Microsoft, Access, 2000 How to Calculate an aproximation of the Distance between two zip codes using a query to Google Maps

My Company does not need a profesional mileage system like PC Miler, but I oftentimes need to calculate the distance over the road between two zip codes.
is there an easy way to return the information using something like google maps?
Ideally I have a form, I enter two zip codes and then click  and the query is created, submited and displayed
Avatar of jdera
jdera

Avatar of TOPIO

ASKER

dear Idera:
The solution has to work for Microsoft Access 2000 and purchasing a package for all the users who might use this function is not an option
ASKER CERTIFIED SOLUTION
Avatar of aesmike
aesmike

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jeffrey Coachman
aesmike, TOPIO

Just to clarify,

EE-stuff.com, does allow zip file uploading.
(EE) aka: Experts-Exchange.com's "Attach File" utility does not. (yet)
(Don't know why either!)
;-)

JeffCoachman
aesmike,

Actually your DB is nicely done.

Clean and neat!
:)

Jeff
Avatar of TOPIO

ASKER

Excellent, Fas Neat and It works
What more can you ask for?