Change the number type to double. -----Original Message----- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:14 AM To: CF-Talk Subject: Rounding in Access
I know this was answered nicely before and I tried the suggestion, but it did not work. In Access I have quite a few number fields that I want to display figures with decimals such as: 210.52. When I do a SQL update using CF it rounds off the decimal place and I get 201 as data. I set the field for number and as Long Integer and General Number and Auto Decimal in the field properties. The Default Value is 0. Any other way I can prevent Access from auto-rounding? Thanks. Robert O. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
