Kristie, REAL is a very limited data type. Even though the scale of the numbers can be big, the accuracy is limited to 6 significant digits. It's stored as only a 32 bit number in the database.
The best solution for you is to change the datatype to DOUBLE, which uses twice as many bits. If changing the data type causes too many side efects in your database and application, in the report, you can create a DOUBLE type variable, and set it equal to the real number, but you will still lose accuracy. Bill On Fri, 7 Dec 2001 11:28:01 -0500, Kristie Wilhelmi wrote: >I have a quick question.... > >I have a column that is "real" and I am trying to key in 10000000(10 million). It shows up as 1.E7 in the table. > >I also print a report with this column on it and have a picture format of 999,999,999 set up, but it still insist on printing 1.E7. > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
