Decimal houses

[Tiago]

Hello everyone,

How can I set up Access to consider more than 4 decimal houses?
I have tried to do this through property both in the tables and in forms,
but it doesn't seem to work.

Thanks in advance!

 

[KARL DEWEY]

Do you mean 'decimal places'?
What kind of number are you using? Try changing to Double.

 

[John W. Vinson]

Hello everyone,

How can I set up Access to consider more than 4 decimal houses?
I have tried to do this through property both in the tables and in forms,
but it doesn't seem to work.

Thanks in advance!

I'm struggling to understand what you mean by "decimal houses". Might this be
a bad translation? Decimal places perhaps?

What datatype are you using?

What are some examples of values that you would like to see and cannot?

Just for reference: the default Number field is Long Integer, which allows
only whole number, no decimals. A Currency datatype allows exactly four
decimals, no more, no fewer. A Single Float number allows approximately seven
digits of precision - i.e. 1233211.0 or 0.1233211 but not 1233211.1123456. A
Double float allows approximately fourteen digits precision. Both Single and
Double suffer "roundoff error" (for instance, 1.0 + 2.0 + 3.0 - 6.0 might not
be 0.0 but rather 0.000000000000023). The Decimal datatype, available in
AccessXP and later, lets you specify the precision and number of decimals, and
may be your best choice.

John W. Vinson [MVP]

 

[Sylvain Lafontaine]

Decimal houses??? If you are talking about the Dewey classification system,
then you will be better served by using a text field than a numerical field.

 

[Tiago]

Hello John,

Literal translations don't always work... I did mean decimal places.
I'm using currency. How can I switch to this "double float"?

Cheers.

 

[Tiago]

Thanks just changed currency to Number double and it worked!!!!

 

[John W. Vinson]

Thanks just changed currency to Number double and it worked!!!!

Just be aware that Double *is an approximation*. If you will be calculating
balances, subtracting numbers, don't forget that you may have differences in
the 14th digit of precision. Just for an example: in the Immediate window type

?.1+.2+.3-.6

The result should be 0.0; in fact it is 2.77555756156289E-17.


John W. Vinson [MVP]