I have a report that has mileage tracking information in it. I have several fields, one being MT_Odometer_Start and another being MT_Odometer_Finish. What I want to do is compare the MT_Odometer_Start from one record to the MT_Odometer_Finish in another record (the previous record). For instance on 2/2/10 the MT_Odometer_Start value is 22000 and the MT_Odometer_Finish value is 22150, that is one record, the next record on 2/3/10 has MT_Odometer_Start of 22170 and MT_Odometer_Finish of 22200. What I want to do is compare the falue of MT_Odometer_Start in the 2/3/10 record to the MT_Odometer_Finish in the 2/2/10 record. I can't figure out how to make the MT_Odometer_Finish value from the previous record available to the current record. If the value of MT_Odometer_Start in the current record is greater than the value of MT_Odometer_Finish in the previous record I want to display MT_Odometer_Start - MT_Odometer_Finish in the report
I am using Access 2007.