Re: FLOAT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I only want to use float datatype because I have to frequenly convert the
database into Access 97 and Access doesn't support decimal and numeric
datatype.

Thanks

"Hugo Kornelis" <hugo@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:q43im1ddb79j8bmre6kugqrjo7nem75f6r@xxxxxxxxxx
> On Wed, 2 Nov 2005 11:19:15 -0500, Rogers wrote:
>
>>I want to use only float datatype but the problem is that it return more
>>than two decimal, I want to minimize to two decimal points? I don't want
>>to
>>use decimal datatype.... I only wanna use float.....
>>
>>The result should looks like
>>
>>152254.45
>>
>>but now it's giving me.
>>
>>152254.45123232363
>>
>>Any solution ?
>
> Hi Rogers,
>
> No, of course not. The FLOAT datatype is designed to *not* have an exact
> and limited number of decimals. The datatypes that are designed to offer
> a fixed number of decimal places are decimal and numeric.
>
> Saying "I want to have two decimal points but I don't want to use
> decimal datatype... I olnly wanna use float" is like saying "I want to
> travel by air but I don't want to use a plane... I only wanna use a
> boat".
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)


.

Relevant Pages

  • Re: FLOAT
    ... The FLOAT datatype is designed to *not* have an exact ... and limited number of decimals. ... Saying "I want to have two decimal points but I don't want to use ... I olnly wanna use float" is like saying "I want to ...
    (microsoft.public.sqlserver.clients)
  • Re: abundance of irrationals!)
    ... >> It seems to me that what he's saying is that the number 0, ... Consider the sequence of rational decimals in which a_n ...
    (sci.math)
  • Re: the seven first decimals of pi
    ... Mike Barnes wrote: ... how do I go about saying ... this (as the above is a bit clumsy)? ... "The first seven decimals of pi are 3,1415926", that's wrong as the ...
    (alt.usage.english)
  • Re: the seven first decimals of pi
    ... how do I go about saying ... this (as the above is a bit clumsy)? ... "The first seven decimals of pi are 3,1415926", that's wrong as the ... Or alternatively the value of pi to seven significant figures is the ...
    (alt.usage.english)