query calculation

  • Thread starter Thread starter Vsn
  • Start date Start date
V

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
 
Back
Top