Query problem

[Domino2]

The following query works

mysql = "SELECT TXC.REPORT, TXC.IDB"
mysql = mysql & " FROM TXM INNER JOIN TXC ON TXM.IDA=TXC.IDA"
mysql = mysql & " WHERE TXC.REPORT & ' ' Like '*" & Me!RPT.Caption & "*' "

However there is a Junction Table (linked from TXC via IDB) which contains names related to the value of IDB.

I am wanting to add a concantenated list of these names in a field at the end of each record produced in the query.

So in a row you would have REPORT, IDB, Concantenated Names

I have a concantenating function. Thanks

 

[Golom]

OK. You have a query and a Concatenate function.

What's the problem exactly?