Rounding Number

C

Chris

I know how to do a calculation and get the integer of a
number, but I want to do a calculation and get the
integer plus one decimal place. My numbers are displaying
with one decimal, but calculating with many decimals, and
it makes the answer look off a little bit. Is there
anyway to actually round off to one decimal place in
Access?
 
M

Marshall Barton

Chris said:
I know how to do a calculation and get the integer of a
number, but I want to do a calculation and get the
integer plus one decimal place. My numbers are displaying
with one decimal, but calculating with many decimals, and
it makes the answer look off a little bit. Is there
anyway to actually round off to one decimal place in
Access?
Click to expand...


Try using the Round function.
 
C

Chris

Has the Round function always worked in Access? For some
reason I thought it didn't work correctly. I guess I had
tried it with calculating age or something like that.
 
M

Marshall Barton

Round wasn't introduced until A2K.

Maybe that's why you have the impression that it didn't used
to work ;-)
 
Top