query calculation

[Vsn]

Hello all,

It seems an easy matter to me but I have no clue how to do this.

I do have a table fID(autonumber, PK), fMilage.

Now between the records I would like to calculate the diffrence of the
milage. Like distance = milage record - milage previous record.

Is this possible with a query.

Thanks,
Ludovic

 

[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&Product=acc2000

 

[Vsn]

Thanks very much for your help, all I needed.

See:
Referring to a Field in the Previous Record or Next Record
at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210504&Product=acc20
00