Round Up in Forms and Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mattc66 - 22 Feb 2008 22:46 GMT

I need to round up on my forms and reports.

Example 20.635 needs to be 20.64

301.125 round up to 301.13.

What do I need in my formula?

Matt

Signature

Matt Campbell
mattc (at) saunatec [dot] com

Reply to this Message

John W. Vinson - 23 Feb 2008 02:52 GMT

>I need to round up on my forms and reports.
>
[quoted text clipped - 5 lines]
>
>Matt

There's a sneaky trick for rounding up: use the Int() function which rounds
down, but do it on the negative of the number. That is, Int(3.5) rounds to 3,
but Int(-3.5) rounds to -4.

To round up to the nearest two decimals, use

-Int(-100 * [field]) / 100.

This will take 20.635 and change it to -2063.5; The Int will take that to
-2064; dividing by 100 and negating will take it to the desired 20.64.

Signature

John W. Vinson [MVP]

Reply to this Message