To explain my dilemma, I have a table called Fuel Usage....there are an number of fields, this issue deals with 3 fields..
1) Unit Number
2) Todays End Mileage Reading
3) Last Ending Mileage Reading
I want the Todays Mileage Reading value in the record to replace the Last Ending Mileage Reading next time a record is created for that Unit Number to record the Todays End Mileage Reading.