The solution worked like a charm. Thanks.
Now I have a similar problem, but more involved. I want to concatenate a field based on 2 criteria fields. Here's the table:
ID1; ID2; Text
1; X; aa
1; X; bb
1; Y; cc
1; Y; dd
2; X; ee
2; X; ff
2; Y; gg
2; Y; hh
2; Z; ii
2; Z; jj
I want to...