[AccessD] Calculating mileage

John,

I have previously used MapPoint to do this using VB6, I had a matrix table
of postcode sectors and calculated the shortest driving distance using that.
 However took quite a while as there were a few hundred thousand, and
couldn't get the code to calculate any quicker than about 2 seconds per
record.  However our old web developer (since left the company), wrote a PHP
page that interfaced with Google and this was much quicker, however I do not
know how he referenced Google etc.

Paul

On 28 September 2011 12:47, jwcolby <jwcolby at colbyconsulting.com> wrote:

> > 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@**databaseadvisors.com<accessd-bounces at databaseadvisors.com>[mailto:
>> accessd-bounces@**databaseadvisors.com<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!
>>
>>  --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>



-- 
Paul Hartland
paul.hartland at googlemail.com