I am trying to use de ConcatRelated from Allen Browne and when I try to run it on a query it's with the error 3471.
I don't understand what it means.
It to be used on a mail merge word document
Add option explicit to the declarations of your module. Then compile it and you will see your errors.
You should always use option explicit.
Code:
Option Compare Database
Option Explicit
your arguments in the function call also dont look right to me New: ConcatRelated("campoacriar","QuotasJuntas","MesAnoValor","QuotasSolicitadas","strSeparador")
You were right, wrong arguments.
Resolved
SELECT DISTINCT ID, ConcatRelated("Mes", "Teste1", "ID = '" & [ID] & "'", "QuotasSolicitadas")
FROM Teste1
Now, I need one of those fields formated as long texto when the table is created