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

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.
 
G

Guest

What is the datatype of the field in you table? Make sure it is number and
field size is single or double.
 
G

Guest

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!
 
R

Rick B

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

Stop Rounding in Forms 2
Preventing rounding numbers to nearest dollar 2
Found a Bug or Error in Access 2002-2003 Round Function 3
How do I stop Access from rounding numbers? 3
Form Combo incorrectly rounding 1
Rounding Numbers 2
Excel Excel 2007 won't stop rounding down my formula results! 5
i'm trying to get the decimal number to NOT round up 3

Top