Hello--
I am working on a database for a transportation company. They have an issue with their trucks being down and out of service which is where my problem begins.
I need to take the MaxOdometer from a trucks previous day in operation (PreviousMaxOdometer) and subtract it from todays MaxOdometer (TodayMaxOdometer). Here is an example of my data:
TruckID | TransDate | Odometer
T1800 | 6/25/12 | 89000
T1806 | 6/25/12 | 99000
T1806 | 6/25/12 | 98700
T1800 | 6/23/12 | 88300
T1806 | 6/22/12 | 98000
T1800 | 6/15/12 | 87000
T1806 | 6/13/12 | 97900
The data should give a (MaxPreviousOdometer) by date so that I can find MPG and such. It also solves the amount of fuel used during a day issue for me. Any help would be greatly appreciated.
Thanks for the help,
aStoerm
I am working on a database for a transportation company. They have an issue with their trucks being down and out of service which is where my problem begins.
I need to take the MaxOdometer from a trucks previous day in operation (PreviousMaxOdometer) and subtract it from todays MaxOdometer (TodayMaxOdometer). Here is an example of my data:
TruckID | TransDate | Odometer
T1800 | 6/25/12 | 89000
T1806 | 6/25/12 | 99000
T1806 | 6/25/12 | 98700
T1800 | 6/23/12 | 88300
T1806 | 6/22/12 | 98000
T1800 | 6/15/12 | 87000
T1806 | 6/13/12 | 97900
The data should give a (MaxPreviousOdometer) by date so that I can find MPG and such. It also solves the amount of fuel used during a day issue for me. Any help would be greatly appreciated.
Thanks for the help,
aStoerm