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
