Charlotte Foust
charlotte.foust at gmail.com
Tue Sep 27 12:32:40 CDT 2011
John, You have a smartphone, right? There's an android app called Mileage Tracker, from Frank Android Software, that lets you do this on you smartphone and export a mileage report to CSV format that can be opened in Excel or whatever. I use it for hospice volunteer and business uses. Charlotte Foust On Tue, Sep 27, 2011 at 8:16 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > 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@**databaseadvisors.com<accessd-bounces at databaseadvisors.com> >> [mailto:accessd-bounces@**databaseadvisors.com<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<http://databaseadvisors.com/mailman/listinfo/accessd> >> >> >> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> >> >> >> >> -- > 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> > > >