Rounding up or down

[tamer64]

Hello,

Can someone assist with rounding a number.

I have textbox called Percentage and I have the format set to Percent and the Decimal place is set to Auto. For the control source I have this:

=([Calc1]/[Vitals])

Calc1 field = 79
Vitals field = 13,304

The output for Percentage is 0.59%

What do I need to do to the control source so the output would give me 0.6% or If the output for the Percenatage was 0.54% the output would be 0.5%

 

[PHV]

What about this ?
=Round([Calc1]/[Vitals],3)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tamer64]

Thank You! PHV. I knew it was something simple like that..