Draw out data from one column

[prometro]

Hi,
I have simple table with three columns.
How I can drow out all data from only one column to textbox (like in picture).

I did it per Dlookup function which find value of first record, then second, third, ... and then I put values together.
But If I will have about 20 records in table this way it is not solution.
Can you help me with it ?

 

[boblarson]

You need this.

 

[prometro]

thank you, I will look at it. Jiri

 

[prometro]

Yes, ... and similiar thing :
How transform data in table from picture1 to picture2 ? ... in example if I want to view only "AAA". Thank you.