Single/double allow for "decimal precision" here's the info from MSOutlook help.
Single Stores numbers from -3.402823E38 to -1.401298E-45 for negative values and from 1.401298E-45 to 3.402823E38 for positive values. 7 4 bytes Storage Size 4 bytes Decimal Precision 7 Double Stores numbers from -1.79769313486231E308 to -4.94065645841247E-324 for negative values and from 1.79769313486231E308 to 4.94065645841247E-324 for positive values. 15 8 bytes Storage Size 8 bytes Decimal Precision 15 -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:26 PM To: CF-Talk Subject: Re: MS Access Help What does double do .... as opposed to decimal? Thanks so much! Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 3:13 PM Subject: RE: MS Access Help > 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 > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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