Decimal Rounding

[clyde]

There must be an easy solution to this, but I can't find it. I want to show numbers to one decimal place. In the table I have defined the field as number-decimal with fixed length format and 1 decimal place. In the table it shows one decimal place, but its always 0 (zero). For instance I need to be able to enter 101.5 and have it appear that way, but instead no matter what I do it shows as 101.0. How do I accomplish what I'm trying to accomplish?

 

[Nikos Yannacopoulos]

Clyde,

I seems you've got the format part right, but possibly
wrong field type... any chance you've set it to integer or
long integer? If so, change to Double, and the job is done!

Nikos

-----Original Message-----
There must be an easy solution to this, but I can't find

it. I want to show numbers to one decimal place. In the
table I have defined the field as number-decimal with
fixed length format and 1 decimal place. In the table it
shows one decimal place, but its always 0 (zero). For
instance I need to be able to enter 101.5 and have it
appear that way, but instead no matter what I do it shows
as 101.0. How do I accomplish what I'm trying to
accomplish?