Recent content by Nita

  1. N

    Query format field

    Thank you, I didn't knew why it didn't work.
  2. N

    Query format field

    It worked. Thank you very much
  3. N

    Query format field

    The ID?
  4. N

    Query format field

    I am working with 2016, but I have 2 databases, I am going to send it, for you to see if you understand
  5. N

    Query format field

    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.
  6. N

    Query format field

    Hi, There it is. Thank you
  7. N

    Query format field

    My filed: Mensal: ConcatRelated("Mes", "Teste1", "ID = '" & [ID] & "'", "QuotasSolicitadas) In the query it's not visible the all when the result is above 255char.
  8. N

    Query format field

    mine just return 255 char, the rest of information does not appear.
  9. N

    Query format field

    This field have no problema, it worked perfectly
  10. N

    Query format field

    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
  11. N

    Query format field

    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"))
  12. N

    ConcatRelated

    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
  13. N

    ConcatRelated

    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
  14. N

    ConcatRelated

    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
  15. N

    Return decimal value

    In that case, what I need is to return 345.
Top Bottom