How to bring data located in an specific row

[jaarroyl]

Please help me to figure out this.

I have this table:

Age      Policy

1          1234

1          12345

2          234

3          3456    

3          34567

3          345678

4          412

I want to concatenate in a text box all the Policies when I select any Age

Example:

Selected Field (Age) : 1

Text box = 1234

                  12345

Selected Field(Age): 3

Text box: 3456

                34567

                345678

Thanks

[sunny_talwar · Accepted solution]

Try this expression

Concat(DISTINCT Policy, Chr(10))

[jaarroyl]

Thanks, always the best!