There's an INT function, which returns the integer value of a number. Rounding is generally controlled simply by altering the display format.
e.g. I have number with 3 decimals: 10.347
Displayed with 2-digit decimal format: 10.35
Displayed with 1-digit decimal format: 10.3
You could also check out the HELP for the type conversion functions.
"Remember, you're unique - just like everyone else"
You're invited to visit another free Access forum:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.