Query using the current record and the previous one

[Luc Dansereau]

Hi,

I have a table containing those fields:
VehiculeNo
Date
Odometer
QuantityFuel

I want to do a query that will count the millage made by each truck between
two date in order to obtain those results:
VehiculeNo
Date
Odometer
QuantityFuel
LastOdometer
Distance (Odomoter - LastOdometer)

Can someone help me on that one ?

Thanks a lot

Luc

 

[Allen Browne]

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210504