Hi Dan,
Well, we are going to lose this mail server in about 50 minutes, for
about 2 days.
So if you want to do this now, perhaps you might want to jump to
www.oooforum.org and post in the Base list and someone will help you
with the SQL statements.
On 30 Apr 2007 16:06:25 -0000, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
dev Digest 30 Apr 2007 16:06:25 -0000 Issue 598
Topics (messages 2501 through 2501):
Queries in Base
2501 by: Dan Lewis
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
---------- Forwarded message ----------
From: Dan Lewis <[EMAIL PROTECTED]>
To: [email protected]
Date: Mon, 30 Apr 2007 11:06:21 -0500
Subject: Queries in Base
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]
