Dan Lewis wrote:
On Wednesday 04 October 2006 04:35 pm, CPHennessy wrote:
On Tue October 3 2006 18:55, + Daan Swardt wrote:
[ MODERATED ] ***********************
Thank you. I have tried this suggested method before but it did
not work. May be the following information wil help.
I use Openoffice.org2.0.3 and have created a database Table for
my car expenses
etc.
so the start milage and end milage should be subtracted to get
the distance traveled for each trip. Some of the fileds (columns)
are ODO BEGIN : ODO END : TRIP :
Normally in the field, TRIP the following formula should appear;
(ODO END-ODO BEGIN) -this is with LOTUS APPROACH- and the
result wil be calculated.
aotomatically when you enter the odo reading into odo begin and
odo end.
So if you have the data "ODO BEGIN", "ODO END", "TRIP" in 3 columns
"A", "B" and "C" then you can type into C2 the string "=B2-A2" to
get the TRIP length. Note that putting in the "=" character first
is important.
Please reply to [email protected] only
CPH: He wants to use Base and you are telling him how to use
Calc. (Do they mix?) More likely, what he wants done would have to be
done in the form of a report perhaps.
Dan
I answered this recently for another user who was asking how to create a
calculated field in a query. It's really quite simple: Create a query
and add all the fields to it, then add another column and type "ODO_END"
- "ODO_BEGIN" in the field name, and "Trip_Len" in the ALIAS field, then
run the query. (NOTE: I changed your invalid field names to valid ones.
A VALID FIELD NAME CANNOT CONTAIN A SPACE),
HTH,
Matt
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
