Thanks, I'm going to use this. I found one small change
I had to make for my purpose. I had to multiply my value
* 100 then divide the final result by 100 to round up to
the 2nd decimal place. Also I had to test for negatives
and remove the minus sign to get the proper result.
IIf([AmountField]>0,Abs(Int(-([AmountField]*100))/100),Int
(([AmountField]*100))/100)
Not sure if I got the parens right here but it does work
in my query, TG.
PH
-----Original Message-----
Try this:
=ABS(INT(-[YourAmountField))
Regards,
ET Sherman
-----Original Message-----
I am looking for a function that will duplicate the Round
Up function in Excel.
TIA
Paul Hammond
Richmond, Virginia
.
.
