ConcatRelated (1 Viewer)

[Nita]

Hi,

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

 

[Gasman]

To save anyone else looking it up that comes back as Failure to write to the Synchronizer log file. from https://www.fmsinc.com/MicrosoftAccess/Errors/ErrorNumber_Description2010.html

What version of access are you using?

Perhaps post the code within code tags?

 

[Nita]

I am using Access 2016.

That's a sample of the database where I have the Module.
If you can find my error I would apreciate.
Thank you

 

[moke123]

Add option explicit to the declarations of your module. Then compile it and you will see your errors.
You should always use option explicit.

Option Compare Database
Option Explicit

your arguments in the function call also dont look right to me
New: ConcatRelated("campoacriar","QuotasJuntas","MesAnoValor","QuotasSolicitadas","strSeparador")

 

[Nita]

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

 

[moke123]