How to Remove 'xx/100' the trailing string, when using ToWords
Left(ToWords(Sum ({YourTable.Field})), InStr(ToWords(Sum ({YourTable.Field})), " and ")) & " and " & ToWords(ToNumber (Right(ToText(Sum ({YourTable.Field})), 2 )), 0) & " cents."
Search
Labels
- asp.net (12)
- cash drawer (1)
- Crystal Report (2)
- DataSet (1)
- DataTable (1)
- gridview (3)
- IIS (1)
- javascript (1)
- List(T) (1)
- MS Access (2)
- MS SQL (2)
- MySQL (4)
- pos (2)
- System.IO (3)
- System.Text (1)
- Xml (1)
Meta
Subscribe To
Posts
Comments
FeedCount
0 comments:
Post a Comment