Miles per gallon for each record

[dr.bob]

I am working on a database to help me compare MPG between using different brands and octane ratings. How do i cause each record to calculate MPG? The database would have to calculate odometer differences from the last odometer reading and divide number of gallons bought.

I hope this is clear.

Thanks,

Dr. Bob

 

[Sergeant]

It really seems like a job for Excel.
(Unless you are already using a fleet management database, and want to add this feature.)

 

[pbaldy]

It should not be difficult to get the previous odometer reading (DMax or subquery would work). From there, a simple matter to get MPG.