I'm having a bit of trouble using this function. As i understand it, the syntax of the function is Round(Numberfield ; Number of decimal places). Assuming the field contains the number 800, this function should return 800.00 when the number of decimal places is 2. Instead though i get 800 ... Is there are work around for this, im not thinking to well at this point.

Cheers,

~Genx

P.S. Theres no formatting or anything attached to the field.

Rounding is not the same as formatting. Rounding is a NUMERICAL operation. In mathematics, 800.001 rounded to 2 decimal places equals 800. Trailing zeros are redundant in a number.

If you need to DISPLAY the result as 800.00, then either format the field to display 2 decimal places, or convert the result to TEXT and do the formatting yourself.

Rightio, thanks for clearing that up comment, I already resorted to just formatting it that way so yeh. At least know i'll know how to expect it to work.

Edited March 14, 200619 yr by Guest