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

Answer 1 / 1
S_sergio Posted messages 8 Status Member 1
 
Hello;
this can be Expr:[CODE] & " (" & [NAME] & [FIRSTNAME] & " )"
0
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