uh...sorry robert. marlon's right...that was a braindead reply on my part. setting the type to double should do it.
~ dina ----- Original Message ----- From: "Marlon Moyer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 31, 2002 10:45 AM Subject: Re: Rounding in Access > Set the type as a Single or Double. Long Integers hold only integer (i.e. > no decimal) values. > > > At 11:13 AM 5/31/2002 -0400, you wrote: > >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. > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
