By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,654 Members | 1,422 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,654 IT Pros & Developers. It's quick & easy.

multiple rows into one column

P: 2
Table: Comment
fields:
No_ Line No_ Comment
SO-0250711 20000 DO NOT SHIP PRODUCT WITH LESS
SO-0250711 30000 THAN 6 MONTHS SHELF LIFE
SO-0250711 40000 PRODUCT DEBE TENER
SO-0250711 60000 6 MESES DE CADUCIDAD

I want to put into a report all the comments belonging to one sales order in one text field
No_ Line No_ Comment
SO-0250711 20000 DO NOT SHIP PRODUCT WITH LESS THAN 6 MONTHS SHELF LIFE PRODUCT DEBE TENER 6 MESES DE CADUCIDAD

Hope I have explained it clear enough and thanks in advance
Lisa
Jun 23 '15 #1
Share this Question
Share on Google+
3 Replies


Seth Schrock
Expert 2.5K+
P: 2,951
There is a function that Allen Browne has created that does just that. See this article for the code and how to use it.
Jun 23 '15 #2

P: 2
but my question is only one table
Jun 23 '15 #3

Seth Schrock
Expert 2.5K+
P: 2,951
It would be the same process. I would just start with a SELECT DISTINCT query to pull unique No_line fields and then use the ConcateRalated function to get your comment field.
Jun 23 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.