Change your field size to 'single' or 'double'. The General Number setting is just for formatting.
----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 3:13 PM Subject: OT: MS Access Help > I am trying to insert numbers into MS Access NUMBER FIELD, > > Numbers are: > > 21.01 > 22.00 > 23.33 > 24.00 > 49.99 > ect... But it keeps rounding them up/down and putting them in as > > 21 > 22 > 23 > 24 > 50 > > I have set the Number Field to General Number and forced(I thought) 2 > decimal places. > > Anyone know Access very well? They don't have FLOAT :( > > Thanks > > Paul Giesenhagen > QuillDesign > > > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
