RE: maintaining decimal place
Britta Jay, Have you tried #DollarFormat(UnitPrice)#? Maybe I'm missing something, but it seems like that's what you want on the CF side. On the Access side, use Fred's instructions. hth, ron allen hornbaker õ¿õ¬ mailto:[EMAIL PROTECTED]~ humankind systems, inc. Thanks Fred! It now displays 14.0 instead of 14., 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 cfelsetd 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.. 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.0I 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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: maintaining decimal place
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.. 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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: maintaining decimal place
I think (not positive on this one) that it has something to do with Access 2000, versus earlier versions. It used to be unnecessary to format a value that came from a currency field or a number field. They were automatically formated from within the database. But, since I've been getting Access 2000 databases (even when converted backwards) it seems it's necessary to use the numberformat() or dollarformat() function. -Deanna 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) Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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.. 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.0I 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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: maintaining decimal place
Thanks Fred! It now displays 14.0 instead of 14., 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 cfelsetd 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.. 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.0I 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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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.0I 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.