I have a table that tracks the total length of trips over time. I want to calculate the length of each individual trip by subtracting the [TotalMileage] from the previous record. Very easy to do In Excel but I want to use Access. I've done internet searches and cannot find code that works. In the table screenshot below I want to calculate the numbers in red.