My Number values in one of my columns are rounding. I do not wantthem to round

  • Thread starter Thread starter nouveauricheinvestments
  • Start date Start date
N

nouveauricheinvestments

I need my numbers to be exact to 4 decimal places. My data type is a
number and the format is 'Standard'. The field size is Long
Integer.
 
An integer does not have decimal. If you need four decimals, exactly, use
Currency data type.

Note that Format is irrelevant for the way data is STORED, the format is
only involved when data is to be DISPLAYED or PRINTED. The data type and the
data type only determines how the data is stored, internally.

Vanderghast, Acces MVP
 
An integer does not have decimal. If you need four decimals, exactly, use
Currency data type.

Note that Format is irrelevant for the way data is STORED, the format is
only involved when data is to be DISPLAYED or PRINTED. The data type and the
data type only determines how the data is stored, internally.

Vanderghast, Acces MVP
Click to expand...

hmm..okay..the only thing about that is that the number I am storing
is not necessarily a dollar value. In fact, if there are 4 decimals,
it is like the pound or yen or some other currency. So it is somewhat
misleading. The currency in this table is not relevant, but still...
 
hmm..okay..the only thing about that is that the number I am storing
is not necessarily a dollar value.
Click to expand...

Neither is the Currency datatype necessarily a dollar value. It's a scaled
huge integer with exactly four decimals, and a range into the trillions. It
can be used for any sort of data for which this scaling is appropriate, not
just money.
 
When you set a field to Currency data type, Access very helpfully sets the
Format of the field to Currency. You can accept that or change that in the
table design. If you don't want the currency format, change the format to
nothing or one of the available formats or a custom format.

The value is still stored as a field with 4 numbers to the right of the decimal.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
When you set a field to Currency data type, Access very helpfully sets the
Format of the field to Currency. You can accept that or change that in the
table design. If you don't want the currency format, change the format to
nothing or one of the available formats or a custom format.

The value is still stored as a field with 4 numbers to the right of the decimal.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...

Okay That works and makes sense...
 
Back
Top