View original (French)

Concatenation with parentheses in Access

pimousse -  
 pimousse -
Hello,

I am currently doing an internship and I am encountering some difficulties with my Access database.

In one of my tables, I have 3 fields:
CODE NAME FIRST NAME EXPR
M.DUP DUPOND MARCEL

I would like to create a 4th column that concatenates the code, name, and first name in the format: M.DUP (DUPOND MARCEL)

I can't seem to get the parentheses to appear. What should I do?

Thank you in advance.

1 answer

  1.
    S_sergio Posted messages 8 Status Member 1
     
    Hello;
    this can be Expr:[CODE] & " (" & [NAME] & [FIRSTNAME] & " )"
    0
    1. pimousse
       
      Thank you very much for replying so quickly!
      The concatenation works =)
      I have a lot of space between the first name and the last name, but I think it comes from my table and not from the formula...
      Thanks again, have a great day!
      0