Single line output from Query

[Lalatech]

Hi I want to create an export wher weare collecting more than on valie for an
ID into one singel field. Sample shown below

Table
ID Value
1 text1
1 text2
1 text3

Output wanted
ID Value
1 text1 | text2 | text3

Can some one help

 

[Jeanette Cunningham]

Hi Lalatech,
here is a link that shows how to do it
http://allenbrowne.com/func-concat.html

here is another link
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Hi Lalatech,
here is a link that shows how to do it
http://allenbrowne.com/func-concat.html

here is another link
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Piet Linden]

Hi I want to create an export wher weare collecting more than on valie for an
ID into one singel field. Sample shown below

Table
ID       Value
1         text1
1         text2
1         text3

Output wanted
ID      Value
1        text1 | text2 | text3

Can some one help

Personally, I would store it properly and turn it into a non-
normalized format using a query... something like fConcatChild at
www.mvps.org/access

but it's your data.

 

[Piet Linden]

Hi I want to create an export wher weare collecting more than on valie for an
ID into one singel field. Sample shown below

Table
ID       Value
1         text1
1         text2
1         text3

Output wanted
ID      Value
1        text1 | text2 | text3

Can some one help

Personally, I would store it properly and turn it into a non-
normalized format using a query... something like fConcatChild at
www.mvps.org/access

but it's your data.