Change the field size to either single or double -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:14 PM To: CF-Talk 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