Search results

  1. 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"))
  2. 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
  3. N

    Return decimal value

    Hi, I have a query with a value in currency, I convert it to number. I can't get only the decimals, can you help me? I am using Access 2016
Top Bottom