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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]