I have it in 2 databases, with same code "ConcatRelated", I used copy, paste.
And what want it's a mix of both, one of them gives the all info, and the other compile 1 just one record.
It was suposed to be 1 record with all the info.
My filed:
Mensal: ConcatRelated("Mes", "Teste1", "ID = '" & [ID] & "'", "QuotasSolicitadas)
In the query it's not visible the all when the result is above 255char.
Hi,
I concatenated that field in other query, and the query itself does not give me more then the 255 char. t is the concatenated field that need to have more than 255 char.
Anyway, your replay will help after I resolve the above isue
Hi, I have a query to create a table, and one of the fields need to be long texto, but my query makes it shor texto, meaning that most of the information does not appear. The filed I nedd to format MesAnoValor: ([Mes] & " de " & (left(tabela1]![datatotal];4)) & " - " & (Format ([Valor];"currency"))
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
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
Hi,
I want the decimals values.
I need both of the values in separated fields.
The value before the "," I know how to get, the value after is the problem.
For example 5,55 I have one field that returns 5 and want another to return 55.
Thank you