I have a database that I have created for my job to track daily fuel and mileage for 60+ pieces of equipment. On my main table I have RecordID, Quarter, Date, Branch, Truck #, Begining Odometer, Ending Odometer and a calculated field for Daily Total Miles. I then linked that database to a new one and have a query for each truck so I can easily see the list of readings without using parameters each time. I have to account for every mile so is there a expression I can use in the linked odometer reading database that will take the beginning odometer on the most current date and show me if there is a difference between the previous date ending odometer?
Example:
Q2 4/27/20 Dallas #21 89,000 89,400 400
Q2 4/30/20 Dallas #21 90,000 90,500 500
I need an expression or way to show in the query that there are 600 miles missing between 4/27 & 4/30.
I hope I explained that well enough. Thank you in advance!
Example:
Q2 4/27/20 Dallas #21 89,000 89,400 400
Q2 4/30/20 Dallas #21 90,000 90,500 500
I need an expression or way to show in the query that there are 600 miles missing between 4/27 & 4/30.
I hope I explained that well enough. Thank you in advance!