
Not applicable
2009-08-10
02:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Euro symbol and ascii code for new line
Hi all,
I have two values that I want to show on separate lines. One of the values should be formatted as money, with the euro symbol. I use chr(13) to separate the two lines. But, this does not work. When I switch to a $ symbol, or something else, it works fine. Please see attachment for an example. It is the same if I use QV 8.5 and 9.
Any ideas, or tips on work-arounds?
3,408 Views
1 Solution
Accepted Solutions

Not applicable
2009-08-10
02:21 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1,542 Views
4 Replies

Not applicable
2009-08-10
02:21 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use chr(10):
=sum(Sales) & chr(10) & money(sum(Cost), '$' )
1,543 Views

Not applicable
2009-08-10
02:21 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have to use & chr(13) & chr(10) for new line.
Regards.

Not applicable
2009-08-10
02:27 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks to both of you! I had the feeling this was an easy one. It seems to work with only chr(10) as well as the combination chr(13) & chr(10).
1,542 Views

Not applicable
2013-07-09
05:52 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
only chr(10) might not work in AJAX client -- use the combination chr(13) & chr(10) instead
1,542 Views
