¿Qué operador se debe usar en Access 2019 para concatenar dos campos o cadenas en una consulta?

Jose Luis mr 0 Reputation points
2024-01-10T15:29:55.1366667+00:00

¿Qué operador se debe usar en Access 2019 para concatenar dos campos o cadenas en una consulta?

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. José Pablo Ramirez (a. k. a. webJose) 440 Reputation points
    2024-01-10T18:59:15.01+00:00

    Si recuerdo bien, & porque es Visual Basic. Por cierto, antes de preguntar en español, cambie el idioma del sitio web (abajo a la izquierda) a Español. No hay garantía de que recibirá respuesta si hace su pregunta en el foro en inglés.

  2. Ken Sheridan 2,756 Reputation points
    2024-01-11T13:42:37.0933333+00:00

    You might like to take a look at Concat.zip in my public databases folder at:

        https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169   This little demo file illustrates the use of a number of concatenation functions.  You'll probably need to use the basic ConcatValues function, with a space as the strSeparator argument.  Any Nulls in the array passed into the function are suppressed.  You can see how it works in the immediate window, using some literal values:    

    ? ConcatValues(" ","Cat","Dog",Null,"Mouse")  

    Cat Dog Mouse     There seems to be a problem with the above hyperlink in this thread.  Copy and paste it as text into your browser.

    0 comments