RoundOf

[nareshreporter]

Hi,
I forgot to ask one more Question in my previous post. How can i roundof a decimal value? say " 1.00 to 1 "
Is there any function to do that? I have gone thru NumberField format property but couldnt find any function. I appreciate if any one can help me out.

Thanks in advance

 

[synapsevampire]

That's round off, not roundof.

There's a function called ROUND, used as in:

round(12.556677,2)

would produce

12.56

round(12.556677)

would produce

12

Your example doesn't need a round, because you are not rounding, you are altering the display attributes for a number, so right click the field and select format field.

If it's a value being converted to text, then use:

totext(12345,0,"")

-k