Numbers are automatically rounding up in Tables, Forms, etc.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to display numbers with decimal points (such as 1.5), but it
keeps rounding the number up (or down depending on the number). So....1.5 is
shown as 2.0. I have changed the decimal points to see if that was the
problem, but even when I set it to 2 decimal places, the number 1.5, rounds
to 2.0. Any help is appreciated.
 
What is the datatype of the field in you table? Make sure it is number and
field size is single or double.
 
Thanks...I did just notice that the help info says "None" under decimal
precision for other number types. That just didn't make sense until you
answered the question....Thanks again!
 
Sounds like you used an integer. Integers, by definition, are whole
numbers - no decimals.
 

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

How do I prevent a number from rounding in Access? 2
Found a Bug or Error in Access 2002-2003 Round Function 3
Stop Rounding in Forms 2
Round up number 2
i'm trying to get the decimal number to NOT round up 3
How do you turn off automatic rounding in a query IIf statement? 2
decimal places 5
Form Combo incorrectly rounding 1

Back
Top