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 : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
