Re: [libreoffice-users] Re: Calculated fields not showing decimal places in BASE query

Sorry Planas, perhaps I have not explained clearly.

I do not want the ID column ( it had to be included to allow me to enter
data into the Rental column).

The example I gave was to show that if I did a select on the decimal field
only it displayed as a decimal
but if I preceded the decimal field in the query with another it displayed
as an integer ( no decimal places)

Hope this clears this up

regards

John

On 7 September 2011 18:00, planas <jslozier@gmail.com> wrote:

> On Wed, 2011-09-07 at 17:34 +0100, John Mullen wrote:
>
> > This gets weirder.
> >
> > Try this:    Create a table CONTRACTS with an INTEGER field (ID)  as a
> > Primary key, set to auto fill
> >  and a decimal field  (Rental) set to 2 decimal places.
> >
> > Add the value 150.00 to the first row.
> >
> > Run the query
> >
> > SELECT "CONTRACTS"."Rental" FROM "CONTRACTS"
> >
> > this returns 150.00
> >
> > Good so far.
> >
> > Now run the query
> >
> >
> > SELECT  1.00, "CONTRACTS.Rental" FROM "CONTRACTS"
> >
> > this returns  1.00    150
> >
> > Any idea why?
>
> You are selecting the value 1 and the all the values in the Rental
> column. Why it is not displaying the decimal places I do not know.
> To select the ID field you need to
>
> SELECT   "ID", "Rentals" or *
> FROM    "Contracts"
>
> > regards
> >
> > John
> >
> > On 6 September 2011 20:48, Andreas Säger <villeroy@t-online.de> wrote:
> >
> > > Steve Edmonds wrote:
> > > > Hi.
> > > > > From the original posters example, he has decimal places, just not
> > > > trailing zeros. I think the calculation is correct just the display
> of
> > > > the result needs formatting. I don't use Base (yet) but is the
> correct
> > > > data type for currency DECIMAL. Can the field display format be set
> by
> > > > right clicking the field in the form as in a form letter.
> > > > steve
> > > The DATEDIF function returns an integer, 7 is an integer. So there is
> no
> > > decimal involved in the calculation and the result is an integer
> despite
> > > the
> > > division. No formatting attribute will change an iteger number. Any
> > > currency
> > > format will end with .00 if the formatted value is an integer one.
> > >
> > > How about this one with the last brace shifted:
> > > ABS( DATEDIFF( 'dd', "RENT_PAYMENTS"."Date_Paid", CURDATE( ) ) )  /
>  7.00
> > > (first get the absolute day difference, then divide by decimal 7.00)
> > >
> > > --
> > > View this message in context:
> http://nabble.documentfoundation.org/Calculated-fields-not-showing-decimal-places-in-BASE-query-tp3313752p3314620.html
> > > Sent from the Users mailing list archive at Nabble.com.
> > >
> > > --
> > > For unsubscribe instructions e-mail to:
> users+help@global.libreoffice.org
> > > Problems?
> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be
> > > deleted
> >
> >
> > --
> > Cheapest mobile tariffs - GUARANTEED <http://www.discoverhow.co.uk/>
> >
> > "I train people to make money" <http://www.makemoney.discoverhow.co.uk/>
> >
> > "Action always beats inaction" - Robert T. Kiyosaki
>
>
>
> --
> Jay Lozier
> jslozier@gmail.com
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted



-- 
Cheapest mobile tariffs - GUARANTEED <http://www.discoverhow.co.uk/>

"I train people to make money" <http://www.makemoney.discoverhow.co.uk/>

"Action always beats inaction" - Robert T. Kiyosaki

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted