Re: maintaining decimal place

[Britta Wingenroth \(Design Department\)]

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.