AnsweredAssumed Answered

Field Data from Last Record

Question asked by LarryMarkus on May 14, 2017
Latest reply on May 15, 2017 by FileKraft

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.

Outcomes