Hi,
Not sure I have to pass by the concatenate build-in fonction. I have a table such as :
col 1 col 2 (is a memo field)
1 a
1 b
1 c
2 d
2 e
I want the output to be like this with new columns :
col 1 col2 col 3 col 4
1 a b c
2 d e
Is there a way to do this by a query ?
Thanks
Not sure I have to pass by the concatenate build-in fonction. I have a table such as :
col 1 col 2 (is a memo field)
1 a
1 b
1 c
2 d
2 e
I want the output to be like this with new columns :
col 1 col2 col 3 col 4
1 a b c
2 d e
Is there a way to do this by a query ?
Thanks