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 Berker