>Hello to everyone,
>I have a numeric (currency) field where I need a mask to just display the cents part of the amount on a report, I've tried a couple of different ways but can't seem to get it to work right. I don't want to display the dollar amount but just the cents.
>So $123.45 should just should up as 45 (important- without the decimal).
>Thanks for any help and suggestions you may have.
>I am open to doing a UDF also in the report, and suggestions if a mask doesn't work will also be considered.
>thanks!
Alp,
Try following expression
INT((MTON(amount)*100)%100)
--sb--