Rounding

[Guest]

I have several number fields. Access keeps rounding them automatically. I have turned off the auto rounding but it still does it. I have set the numbers to format as fixed and decimal places to 3. Please help.

 

[Cheryl Fischer]

Jannie,

In a table, the default Number Format is Long Integer, which will never
produce decimal places. In design view of your table, you can change the
format of your Number fields to Double, Single, or Currency and set the
desired number of decimal places.


hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I have several number fields. Access keeps rounding them automatically.

I have turned off the auto rounding but it still does it. I have set the
numbers to format as fixed and decimal places to 3. Please help.

 

[Van T. Dinh]

You probably set the Field Sizes to Long / Integer or Byte. Since Long /
Integer / Byte cannot store decimal values, value will be rounded before
being stored in the Table.

Check and make sure the Field Sizes are either Single / Double / Decimal or
Currency which can store decimal values.


--
HTH
Van T. Dinh
MVP (Access)

I have several number fields. Access keeps rounding them automatically.

I have turned off the auto rounding but it still does it. I have set the
numbers to format as fixed and decimal places to 3. Please help.

 

[Guest]

Thanks for your help. It worked.