Hubert, >From MS Access 97 help screen: "Currency data type A data type that is useful for calculations involving money or for fixed-point calculations in which accuracy is extremely important. This data type is used to store numbers with up to 15 digits to the left of the decimal point and 4 digits to the right. The type-declaration character in Visual Basic is @." I've had to to stuff like multiply, round, divide to get around this. Yukk. HTH Ben -----Original Message----- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 6:33 AM To: CF-Talk Subject: Trouble with controlling decimal places in Access table currency datatype Hi, I'm having trouble controlling the number of decimal places that is used by a column in an Access table with currency datatype. Although I set the number at 2, I keep getting 4. I'd appreciate any advice. Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft & More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
