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. > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
