Re: maintaining decimal place

[Britta Wingenroth \(Design Department\)]

That was exactly what I needed...

Thanks a lot for your help!
Britta

----- Original Message -----
From: "Fred Sanders" <[EMAIL PROTECTED]>
To: "Britta Wingenroth (Design Department)" <[EMAIL PROTECTED]>
Sent: Tuesday, April 25, 2000 9:31 AM
Subject: Re: maintaining decimal place


> Sorry didn't read far enough down to see your example.
>
> #decimalformat(unitprice)#
>
> or since you want it to be a dollar amount how about
> #DollarFormat(unitprice)#  then you can take the $ out.
>
> ----- Original Message -----
> From: "Britta Wingenroth (Design Department)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 25, 2000 10:51 AM
> Subject: Re: maintaining decimal place
>
>
> > Thanks Fred!
> >
> > It now displays 14.0 instead of 14.0000, and if I add .95 it displays
> 14.95,
> > so this is effective to be able to do calculations.  Any suggestions
about
> a
> > fix for the missing 0 in display?  It's only cosmetic I know that would
> make
> > it perfect!
> >
> > I've tried doing this  to adjust the display:
> >
> > <CFIF UnitPrice IS NOT "">
> > AND UnitPrice IS LIKE '%.0'
> > <td align="center"><font size="2">$#UnitPrice#0</font></td>
> > <cfelse><td align="center"><font size="2">
$#UnitPrice#</font></td></cfif>
> >
> > The problem is that it prints out a line of
> > AND UnitPrice IS LIKE '%.0'
> > for every product in the search.
> >
> > Thanks again for your help!
> > Britta
> >
> > ----- Original Message -----
> > From: "Fred Sanders" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 25, 2000 7:33 AM
> > Subject: Re: maintaining decimal place
> >
> >
> > > Set the Data Type to "Number",Field Size to "Double", Format to
"Fixed"
> > and
> > > Decimal Places to "2".
> > > That should do it for you two.
> > >
> > > Fred
> > >
> > > ----- Original Message -----
> > > From: "Britta Wingenroth (Design Department)"
<[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Tuesday, April 25, 2000 1:55 AM
> > > Subject: Re: maintaining decimal place
> > >
> > >
> > > > I'm looking for the answer to the same question.  I'm using Access
and
> > as
> > > > long as I have my values set as currency, once the query runs $14.00
> > turns
> > > > into14.0000.  If anyone could help, we'd both appreciate not loosing
> our
> > > > minds!
> > > >
> > > > Britta
> > > >
> > > > ----- Original Message -----
> > > > From: "Jay Wigginton" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Monday, April 17, 2000 10:10 AM
> > > > Subject: maintaining decimal place
> > > >
> > > >
> > > > > I am having trouble for some reason with having data entered via a
> > form
> > > > into
> > > > > an Access database  and keeping the decimal places entered in
> place...
> > > > > person enters 2.5 the database rounds it to 2...  if I set the
> > database
> > > to
> > > > > number, type double... it maintains the decimal places but then CF
> > > > displays
> > > > > all the numbers entered with a decimal place and a zero added...
> 2.5
> > > > > entered displays as 2.5.... 181 entered displays as 181.0    I
have
> > > never
> > > > > had this problem before that I can remember....   Am I losing my
> mind
> > > here
> > > > > and just not doing something right?
> > > > >
> > > > > thanks
> > > > > Jay
> > > > >
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > > ----
> > > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > > To Unsubscribe visit
> > > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > or
> > > > send a message to [EMAIL PROTECTED] with
'unsubscribe'
> > in
> > > > the body.
> > > > >
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > ----
> > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > To Unsubscribe visit
> > >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > > the body.
> > >
> >
>
> --------------------------------------------------------------------------
> > ----
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> > >
> >
>
>

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.