need a built in function to fix a number to its upper number

[Mota]

Hi;
I want to get the nearest greater number from a fractional number.For
example,getting 4 from 3.2
It is to find the pages number of a report while its not open,based on the
RecordCount of its RecordSource.
Is there a Built in function to do this for me?
Thank you for your help.

 

[Guest]

Try this
Int(MyNumber + 0.5)

 

[Guest]

Out of curiosity: How does Record Count ever get to be fractional? It is
always a whole number by definition.

 

[Guest]

Sorry about that! I really should spend more time reading <g>

 

[John Nurick]

Try this
Int(MyNumber + 0.5)

That doesn't do what Mota asked (e.g. 3.2 --> 4). Something like this
should do the job:

Int(X) + Sgn(X - Int(X))

If it doesn't produce the desired results when X < 0, replace Int() with
Fix().

 

[Guest]

You are right, I am sure I tried it and it gave the right resault
So in that case you can use

round(MyNumber + 0.5)

 

[John Nurick]

I felt that my version would be faster because it avoids the
(comparatively) slow and complicated floating point operations of
Round(). Some casual esting suggests that it is ... but that the
difference is only significant if you've got a loop that's calling the
expression many thousands of times.