General information
Category:
Coding, syntax & commands
Title:
Input mask for numeric to just get cents part in report
Environment versions
Network:
Windows 2003 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only