Not trying to be mean or anything, but you folks need to avail yourselves of
CF Studio's excellent Help system: specifically CF TAG/FUNCTION Reference.
Folks don't mind helping, but you have to try to help yourself first--... ;)
Britta: Look into #DollarFormat(some_currency_value)#
Jay: Look into #DecimalFormat(some_number)# OR #NumberFormat(some_number)#
(with the latter you can use format masks)
Cheers,
--
David L. Rice
Web Development Consultant
[EMAIL PROTECTED]
Q: 177820
24/7 cell: 770.354.5953
----------------------------
> -----Original Message-----
> From: Britta Wingenroth (Design Department)
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 2:55 AM
> To: [EMAIL PROTECTED]
> 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=list
s/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.
