Just be aware that many of the main players (Google, Map Quest, etc) have restrictions on what you can do with their API's.  For most, it's a limit on the number of calls you can make in a 24 hour period.

 If it's a commercial product that your building this into, then you'll must likely need to purchase a license.

Jim.

Thank you for your quick reply.

I opened the database but it appears to be a membership database. How do i navigate to the address screens?

Sorry,  click on members, then double click on any member ID.  Don't forget to put in an address.

The example is just to show you how to use one of these API.  I have two different ways to map an address.

Pretty slick!

I'll have to check with Google for a license for their API.

Do you have any idea what that would cost?

WOW!

Jeff, that's exactly what I am looking for - just the mileage not directions.

Is the code, that you included, the only code necessary to fetch the mileage value?

Does Google have limitations on this? I am trying to do something for the company that includes a mileage calculation between two points. There will be many users daily on this. Does the company have to buy a license from Google to use its mileage calculator?

Using lat and long of postal codes is not accurate enough. I need point-to-point.

Each of the API's does something different.  I only did a quick scan and picked the one that looked like it returned a number rather than a map.  There may be other options.

Many uses are free for small numbers of transactions in a time period and others require a fee.  Google can help you figure this out.

Thank you!!

Let us know which API you ended up with and the cost if wasn't free.  Also, don't forget to close the question.

Google rates are not that bad, in fact virtually free, unless you are going to develop a commercial application