Round Up in Access

E

Eef Houniet

Hello,

Excel (2003) has the function (in Dutch):
=AFRONDEN.NAAR.BOVEN(A1;0)

in English ROUND.TO.UP or something like that (I hope).

I have not found anything similar in Access (2003) that always rounds
upwards.

The procedure: Me.txtNumber2 = Round(Me.txtNumber1) rounds up or down and
does not what I need.


Thank you for any assistance

Eef Houniet
 
E

Eef Houniet

Al and Joseph,

Thank for your prompt reply.
However, could you please be more clear? It does not yet work.

In field Me.txtNumber1 comes the result of previous calculations.
this result must be rounded up to form the base for further calculations.

By adding a number those calculations are not right.

Thank you again

Eef Houniet.
 
E

Eef Houniet

Al and Joseph,

Thank for your prompt reply.
However, could you please be more clear? It does not yet work.

In field Me.txtNumber1 comes the result of previous calculations.
this result must be rounded up to form the base for further calculations.

By adding a number those calculations are not right.

Thank you again

Eef Houniet.
 
E

Eef Houniet

Al and Josehp

Once more thanks for the trouble.

What I need is to round up a number, no matter what comes after the comma.
And the solution has been found.

In an expression:
=Round((([Number1]/[Number2])+0,4999);0)

Greetings
Eef Houniet
 
E

Eef Houniet

Al,

The solution seems to be to add 0,4999 to a number, and then to roun that in
the normal way.

Thank you for your trouble.
 
Top