: One question  in Access (2003).
:
: I need to accomplish this "rounding" task in MS Access 2003
:
: 1) If it is 10.000001 it should be 11
: 2) If it is 10.999999 it should be 11 too.
:
: In other words, I just need the exact functionality of the CEILING()
: function  thats available in MS Excel.

I am not familiar with the Access, but I have run into a similar
problem in computer languages which do not offer a ceiling function.
Try something like this. "int" is the integer function available in
most languages. (I didn't test this on negative numbers.)


' Ceiling
If number > int(number) Then number = int(number) + 1