Rounding numbers

L

lamera2

I am having a hard time trying to find how I would "turn off" the rounding
function for some numeric data in a text box. I am using Access off of the
latest Windows XP.
 
D

Douglas J Steele

Access doesn't usually round off numbers.

If what you're finding is that you're losing all decimal points, the most
common cause is that you accidentally accepted the default Field Size of
Long Integer for a numeric field. Change that to Single or Double, and you
should be fine.
 
L

lamera2

I tried that but it still doesn't work. I am trying to input Grade Point
Averages into a data field and if I input 3.67 it rounds up to 4.00 or if I
input 3.23 it rounds down to 3.00. I have no idea what else to do.
 
D

Douglas J. Steele

When you say you "tried that", what did you change the Field Size of the
numeric field to?
 
Top