Number Fields

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

When I enter a decimal in my field it rounds to the
nearest whole number, yet I set 2 as the number of
decimal places for the field.
 
Chances are that your field format is set to a Long Integer or Integer
format. Change it to Single or Double if you want decimal fractions.
 
Tony

In addition to Ken's suggestion, you may wish to consider using the
"Currency" type. This data type uses a maximum of 4 decimal places and is
guaranteed accurate to all four. The single and double data types are
subject to errors introduced by their binary storage.

Good luck

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimals, rounding off 4
Number Field Automatically Rounding Decimals 3
Number format issue Access 2007 2
Digits on right of Decimal points 1
Access stripping decimal places in query 1
dumb data type question 5
Troubleshoot general number fields 2
How do I stop rounding of my calculation results. 6

Back
Top