Group concat

[iostream]

how to get from this:

id string
1 A
1 B
2 C

to this:

id string
1 A B
2 C

I found solution (in SQL), but in Access it isn't working !

SELECT id, GROUP_CONCAT(string SEPARATOR ' ') FROM table GROUP BY id;

Do you know any other solution this problem ?

[pbaldy]

In Access it's typically done with a function. Here's an example:

Return a concatenated list of sub-record values