JanetStackpole
Programmer
I have a report listing fuel transactions grouped by vehicle id . It has the following columns
Vehicle id | fueling date | gallons | cost | odometer | miles between fueling |
I am using {odometer} - Next({odometer})to calculate the miles between fueling. This works very well until the vehicle id changes. It then calculates the difference between vehicle 1's odometer and vehicle 2's odometer.
eg vehicle id | date | gallons | cost | odometer | Miles between
32-101 3/11/06 10 20.00 90,000 200
32-101 3/1/06 10 20.00 89,800 19,800
32-102 3/9/06 10 20.00 70,000
Is there a way to correct this?
Thank you very much
Vehicle id | fueling date | gallons | cost | odometer | miles between fueling |
I am using {odometer} - Next({odometer})to calculate the miles between fueling. This works very well until the vehicle id changes. It then calculates the difference between vehicle 1's odometer and vehicle 2's odometer.
eg vehicle id | date | gallons | cost | odometer | Miles between
32-101 3/11/06 10 20.00 90,000 200
32-101 3/1/06 10 20.00 89,800 19,800
32-102 3/9/06 10 20.00 70,000
Is there a way to correct this?
Thank you very much