Query using the current record and the previous one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luc Dansereau - 25 Nov 2005 06:27 GMT

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

Reply to this Message

Allen Browne - 25 Nov 2005 07:06 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi,
>
[quoted text clipped - 14 lines]
>
> Can someone help me on that one ?

Reply to this Message