I need a query in Access with which I can combine the following tables.
I have a table with two columns.

Table1:

FIELD1     TEXT1
112           TAT? TATA
112           LA LA LA
322           HALL HALLO
322           LOL ROLF LOL
How do I get SQL to combine 112 and 332 so that something like this comes out?

112           TAT? TATA, LA LA LA
322           HALL HALLO, LOL ROLF LOL
I tried this code, which unfortunately does not work

SELECT 
FIELD1, 
SQLListe("SELECT TEXT1 FROM Table1 WHERE [FIELD1] = " & [FIELD1],",",",") AS Result
FROM Table1
GROUP BY FIELD1