[AccessD] Calculating mileage

jwcolby jwcolby at colbyconsulting.com
Tue Sep 27 07:49:53 CDT 2011


 > 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.
>



More information about the AccessD mailing list