roundup

[Guest]

Dear All,
I am not a programmer, but try to use Access my using macros only. my doubt
is, is there any function/command which i can use in access macros - same
like the Excel function of Roundup(). The reason is if i have a value as
1.454 i want this to be rounded up as 1.46. Could anyone please guid me.

Thanks..john britto

 

[Guest]

Hi, John.

No, there's no function AFAIK that does what you're asking, but you can
easily create it. Assuming you want to set a form or report control equal to
the rounded up value of another control, it would be something like:

=IIf([Ctl1]>Round([Ctl1],2),Round([Ctl1],2)+0.01,Round([Ctl1],2))

Hope that helps.
Sprinks