[AccessD] Calculating mileage

 > Just out of interest how do you work out the route to get the mileage?

I *thought* that was the precise question I asked in the first email of this thread.  How *do* I do 
that?

My thought was to use a mapping program such as MapPoint.  MapPoint has VBA behind it and it has an 
API.

AFAICT MapPoint and other such programs already pretty much calculate shortest distance.  That is 
actually good enough and in fact what I want.  I pretty much don't care, not do I have any clue what 
actual route was driven.  If the user wanted to take the inmate on a tour of another city while 
driving them from point a to point be, that is not my concern.  What I actually need is "what would 
a map program say was the route and what was that distance".

If I don't have an actual log (and I don't!!! and I CAN'T!!!) then this is what the IRS will want 
for documentation.

John W. Colby
www.ColbyConsulting.com

On 9/28/2011 7:13 AM, Martin Reid wrote:
> John
>
> Just out of interest how do you work out the route to get the mileage? (I understand what you are doing by the way). I was thinking that they only may pay for the shortest route between A and B and C
>
> Martin
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: 28 September 2011 12:08
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Calculating mileage
>
> But... I have database records already in a database.  This is not about defining a solution for data that does not exist and I would otherwise have to enter.  This is about defining a solution for data that I (and any other user) must enter into the database to use the inmate pass program.
>
> *It is already in the database*
>
> This is about building a small program to do these calculations about data that has and *is going
> to* accumulate in the course of doing business.
>
> It appears that I am not able to get across to this list the fact that the records already exist in a database.
>
> Forget that I am driving.  *Just please forget that fact.*   I never said anything about actually
> driving these miles, being in a car or anything else related to automobiles.
>
> Now...
>
> I have records in a database which have addresses in them.  I need to calculate driving distances between those addresses.
>
> Pleeeeeeaaaaaaase, I do not want nor do I need anything related to logging miles driven in a car.
>
> I need a function which takes two addresses and hands back miles between those points, actual miles that would be driven.
>
> BUT I AM NOT DRIVING THOSE MILES.  The records are somehow just magically (poof) appearing in a table!
>