Thanks Leslie for your reply!!! Yes I want the final record to be included. I want the the table to show the final miles calculated for each state entered.
I have a table where we record fuel purchases and when a truck crosses a state line.
I need to calculate how many miles each truck traveled in the states it passed through.
Key Truck_Name Odometer Date State Gallons Dollars
Auto# Text...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.