Maybe I do not understand SQL well enough, but I have a problem. I have a table for fuel that I buy as well as the odometer reading when it is bought. I would like to calculate the fuel economy (quantity of fuel divided by the distance traveled). How do I subtract the odometer readings from adjacent rows to get the distance traveled? I have a few other databases which require subtracting one row of a field from other row.
Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]