Troubleshoot general number fields

[Teri]

My data field is set to general number which should display the data as it is
entered into the field. However, all of my decimals are rounding to whole
numbers. The data includes both decimals and whole numbers so I can't format
the feild to be decimals only. Any help is much appreciated.

 

[Nikos Yannacopoulos]

Teri,

General number is a format, not a data type. Check the field size
property; it should be single or double, if you want it to hold
decimals. If it's integer or long integer it won't.

HTH,
Nikos

 

[Jeff Boyce]

Teri

The format (display) of a field and the data type (inherent underlying data)
are not the same properties. If you have a "number"-type field that only
displays whole numbers (?integers), there's a very good chance that the
field is defined as an integer data type. If you only need 2-4 decimal
places, may I recommend a "currency" data type?