Number rounding

I have a number field. I want to enter data into as a percentage of
commission (2.25). I have tried every number combination and when I enter
2.25 it enters 2.00. It seems to round up or down on the .5. This is just a
straight entry that later may be used for calculation. What is wrong???
Thanks!

What type of field are you using?



"Sam" wrote in message
...
I have a number field. I want to enter data into as a percentage of
commission (2.25). I have tried every number combination and when I enter
2.25 it enters 2.00. It seems to round up or down on the .5. This is
just a
straight entry that later may be used for calculation. What is wrong???
Thanks!

It sounds like you are using an Integer datatype. Integers are whole numbers
only and have no decimal portion.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I have a number field. I want to enter data into as a percentage of
commission (2.25). I have tried every number combination and when I enter
2.25 it enters 2.00. It seems to round up or down on the .5. This is
just a
straight entry that later may be used for calculation. What is wrong???
Thanks!

I have it as a number field. If I use text it will accept my entry as 2.25,
but I need to be able to use it as a calculation later. If I use a number
field it automatically goes to Integer. All I want to do is to be able to
enter a number as 2.25 and have it appear the same and later be able to use
as a calculation. Thanks for your help!

"Lynn Trapp" wrote:

It sounds like you are using an Integer datatype. Integers are whole numbers
only and have no decimal portion.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I have a number field. I want to enter data into as a percentage of
commission (2.25). I have tried every number combination and when I enter
2.25 it enters 2.00. It seems to round up or down on the .5. This is
just a
straight entry that later may be used for calculation. What is wrong???
Thanks!

I have it set as a number. If I use a text field it will let me input it as
2.25, but I am going to need to be able to calculate it later. When I enter
2.25 it accepts the decimal places but displays it as 2.00. Thanks for your
help!

"Rick B" wrote:

What type of field are you using?



"Sam" wrote in message
...
I have a number field. I want to enter data into as a percentage of
commission (2.25). I have tried every number combination and when I enter
2.25 it enters 2.00. It seems to round up or down on the .5. This is
just a
straight entry that later may be used for calculation. What is wrong???
Thanks!

Change your field size to "single"


"Sam" wrote in message
...
I have it as a number field. If I use text it will accept my entry as
2.25,
but I need to be able to use it as a calculation later. If I use a number
field it automatically goes to Integer. All I want to do is to be able to
enter a number as 2.25 and have it appear the same and later be able to
use
as a calculation. Thanks for your help!

"Lynn Trapp" wrote:

It sounds like you are using an Integer datatype. Integers are whole
numbers
only and have no decimal portion.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I have a number field. I want to enter data into as a percentage of
commission (2.25). I have tried every number combination and when I
enter
2.25 it enters 2.00. It seems to round up or down on the .5. This is
just a
straight entry that later may be used for calculation. What is
wrong???
Thanks!

Sam wrote:

I have a number field. I want to enter data into as a percentage of
commission (2.25). I have tried every number combination and when I enter
2.25 it enters 2.00. It seems to round up or down on the .5. This is
just a
straight entry that later may be used for calculation. What is wrong???
Thanks!

Sam,

You need to check the field's "FieldSize" property. If it is set to Integer
or Long Integer it won't allow you to store numbers with decimal portion.
That's what was suggested by Rick and Lynn earlier on this thread. You
should try the Currency data type.

--
Randy Balbuena

Unfortunately, Access refers to the datatype as Number and the FIELD SIZE as
"Long Integer," "Single," "Double," etc. These are the actual datatypes. You
need to change the Field Size to either Single, Double, or Currency to get
what you want.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I have it as a number field. If I use text it will accept my entry as
2.25,
but I need to be able to use it as a calculation later. If I use a number
field it automatically goes to Integer. All I want to do is to be able to
enter a number as 2.25 and have it appear the same and later be able to
use
as a calculation. Thanks for your help!

"Lynn Trapp" wrote:

It sounds like you are using an Integer datatype. Integers are whole
numbers
only and have no decimal portion.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I have a number field. I want to enter data into as a percentage of
commission (2.25). I have tried every number combination and when I
enter
2.25 it enters 2.00. It seems to round up or down on the .5. This is
just a
straight entry that later may be used for calculation. What is
wrong???
Thanks!