round up function

[ocan]

what is the equivalent of round up in access?

Regardless of the number I always want to round up to the nearest 1.

I appreciate your help.

Thanks,
Angie

 

[Remou]

?round(2.55,0)
3
?round(2.5,0)
2
?format(2.5,"#")
3
?format(2.55,"#")
3

"The Round function performs round to even, which is different from round to larger."
--Microsoft

Format always rounds up

 

[ocan]

still having problems.

I'm trying to do this function in a report with a text box

Text24=244.1 I want another box(text25) to ready 245

I put in the control source of text 25:
?format([Text24],"#")

It gives errors. Am I not putting it in right? or do you have another method?

 

[Remou]

Apologies, I misread your post:

[tt]=IIf([Text24]> Int([Text24]), [Text24] + 1, [Text24])[/tt]

The ? was to illustrate. It is from the immediate window. Format only rounds up where the decimal is >=.5. I should not have used the word 'always'.

 

[ocan]

That works great. Thanks.