[AccessD] Calculating mileage

Rocky Smolin rockysmolin at bchacc.com
Tue Sep 27 08:08:29 CDT 2011


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




More information about the AccessD mailing list