[AccessD] Calculating mileage

I don't know about mapquest or googlemaps.  I am looking at doing this with vba and MapPoint which 
is Microsoft's software that I already own.  It looks like it is going to be pretty easy to do it. 
I will be building a table which processes each Pass Request and stores the computed values in a 
TripMileage table.  If I do this on my server then it will be calculated for every user of the 
database and I can just build a report in the application we use for the pass paperwork, to display 
the data for each volunteer.

John W. Colby
www.ColbyConsulting.com

On 9/27/2011 9:08 AM, Rocky Smolin wrote:
> Is there a way for your app to send start and end points to MapQuest or
> GoogleMaps and have them return the mileage?
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, September 27, 2011 5:50 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Calculating mileage
>
>   >  Seems very complicate when you can just record the start/finish mileage
> readings of the car for each trip.
>
> Yes but I keep forgetting to enter the start / stop readings.
>
> A program, once created, just works on whatever data is there.  Since I have
> to file paperwork for the checkout process, and since those records are
> permanently stored in my database, I always have a record of what I did.
>
> It doesn't seem "very complicated" though it could become so I suppose.  The
> database has my home address, that is the start / stop point.  The database
> has the prison camp address, that is the endpoint of the first leg and the
> start point of the last leg.
>
> 1) Calc home to prison
> 2) Calc prison to first stop
> 3) Calc first stop to second stop
> 4) Calc second stop to third stop
> 5) Calc third stop to prison
> 6) Calc prison to home
>
> Each becomes a record in a table with the pass request ID as the FK that
> ties them into a single "trip".  Any pass request IDs not in the trip table
> need to be calculated.
>
> Report.
>
> AFAICT the IRS is not going to dispute the figures.  There are logs (a file)
> at the prison that proves I did in fact checked the guys out, and by law I
> am supposed to take them where I say I am taking them.  They actually do
> occasional checks where they send officers out to see that you are where you
> say you are going to be.
>
> John W. Colby
> www.ColbyConsulting.com
>
> On 9/27/2011 8:16 AM, Stuart McLachlan wrote:
>> Seems very complicate when you can just record the start/finish
>> mileage readings of the car for each trip.  And that would probably be
>> more acceptable as a record by the IRS rather than a notional mileage
> based on maps.
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>