Prev: Combining Dup Info
Next: Query Criteria issue
From: Dave on 14 Apr 2010 12:16
I have a recordset that has a common identifier with comment information on
multiple lines. I want to create a query that diplays the multiple lines in
a single line. I will send this off into another table.

So...

ID Comment
123 Hello
123 Dave


would equal 123 Hello Dave
From: Marshall Barton on 14 Apr 2010 12:59
Dave wrote:

>I have a recordset that has a common identifier with comment information on
>multiple lines. I want to create a query that diplays the multiple lines in
>a single line. I will send this off into another table.
>
>So...
>
>ID Comment
>123 Hello
>123 Dave
>
>would equal 123 Hello Dave


Try using a function like the one at
http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16&SID=453fabc6-b3z9-34z6zb14-a78f832z-19z89a2c.html

--
Marsh
MVP [MS Access]
From: John Spencer on 14 Apr 2010 20:35

Here are links (url) to three examples.

Duane Hookom
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16

Allen Browne
http://allenbrowne.com/func-concat.html

The Access Web
http://www.mvps.org/access/modules/mdl0004.htm

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Dave wrote:
> I have a recordset that has a common identifier with comment information on
> multiple lines. I want to create a query that diplays the multiple lines in
> a single line. I will send this off into another table.
>
> So...
>
> ID Comment
> 123 Hello
> 123 Dave
>
>
> would equal 123 Hello Dave
 | 
Pages: 1
Prev: Combining Dup Info
Next: Query Criteria issue