Round Up in Access

[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

 

[Al Camp]

Eef,
Try
Int(YourNumber) + 1
50.2 = 51
50.9 = 51
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Joseph Meehan]

Eef,
Try
Int(YourNumber) + 1
50.2 = 51
50.9 = 51

I suspect you will want to add something to allow for 50.0

Something like IF (result) = (YourNumber)+1 then (result)

 

[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.

 

[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.

 

[Al Camp]

Give specific examples of your calculations, and what you want.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Joseph Meehan]

Al and Joseph,

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

If you used my example as I wrote it, it likely will not work. I did
not do my homework and check the proper syntax.

 

[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

 

[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.