how to round a number to the max value

[Gab]

hi has anyone have to round a number to the maximun value? for example if i
have 3.8 the result will be 4 and if i have 3.2 also have 4 as the round
number?
thanks for your help.

 

[Tom Wickerath]

Hi Gab,

Try this Knowledge Base (KB) article. Disregard the "ACC2000:" in the title,
since it should apply equally well to other versions of Access:

How to Round a Number Up or Down by a Desired Increment
http://support.microsoft.com/kb/209996

You might also find these KB articles of interest:

Round or Truncate Currency Values to the Intended Number of Decimals
http://support.microsoft.com/kb/210564

Rounding Errors When You Use Floating-Point Numbers
http://support.microsoft.com/kb/210423


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Geni Ezequiel]

hi has anyone have to round a number to the maximun value? for example if
i
have 3.8 the result will be 4 and if i have 3.2 also have 4 as the round
number?
thanks for your help.