It's set to auto. After hours of stumbling around try'n sql functions and CF formatting I finally tried the left function in the SELECT statement.
<cfquery name="CourseDetail" datasource="OITracker" dbtype="OLEDB"> SELECT CourseName, CourseDate, LEFT(CourseHours, 6) As CourseHours FROM Course WHERE Course.CourseID = #URL.CourseID# </cfquery> For what ever reason this works and pulls in the decimals as I intended them to be. So this will serve as a work around for me, but I still don't understand what's going on. Thanks -----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:35 AM To: CF-Talk Subject: RE: Trouble with Access and Single Numbers Do you have the decimal places set to something other than Auto? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:41 AM To: CF-Talk Subject: Trouble with Access and Single Numbers I'm having some trouble with pulling some values out of Access. The field is defined as a "number" with a "field size" as single. The problem is CF is retrieving some decimal values all funny. 2.6 is retrieved as 2.5999999 1.7 is 1.7 1.9 is 1.9 2.9 is 2.9000001 9.99 is 9.9899998 Crazy stuff. They all look fine and as they with in Access but when I retrieve them with a straight Select in CF funny things happen. I can only guess that it something to do with "single" precision thing, but what to do. Any help Thanks in advance > Doug Kronenberger > OI National Training and Education Office > Department of Veterans Affairs > > 440-526-3030 x7776 [EMAIL PROTECTED] ______________________________________________________________________ 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