Number field...how does one show decimal places ?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi,
I created a new field and chose Data type number. It is Field Size Long
Integer by default
I noticed in table view, having typed 3.05 into it, it became 3.
I have altered Decimal Places to 2, it had been Auto by default
that made no difference.
I have made Format generalNumber, it was blank by default,
still makes no difference.
still its rounding things up or down. 3.9 becomes 4 etc..
I need it to show decimal places in table view.

What am I doing wrong ?

I am unable to enter any data and make use of the display until I resolve
this !

Steve
 
A Long Integer data type is an integer data type -- meaning that it only
displays and stores whole numbers. Change the Field Size of that field to
Single or Double if you want to have decimal places in your numbers.

Note that Single and Double are floating-point numbers, so if you want
accurate decimals (no rounding or "floating"), then use the datatype of
Currency to get accurate decimals to 4 decimal places.

Decimal is another possible choice as the Field Size (Number datatype), but
it's behavior is described as buggy in pre-2007 versions. I'm not sure if it
behaves better in 2007 version, but you might want to try it.
 
Ken,
Silly me...Integer = whole number, forgot my school maths, many yrs ago.
Thanksfor the advice, now with Double and all's well.
Steve
 
Back
Top