RE: MS Access Help
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
Re: MS Access Help
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
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 > > > > __ 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
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 __ 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