Adding text in seperate coulumns to be joined in a single column

[Mark909]

I want to add the contents of several columns containing text together to
create all single column with all the text from each row combined.

In excel the query would be:

=CONCATENATE(A2,B2,B3,B4)

How do you do this in Access?

 

[Rob Parker]

NewField: [A2] & [B2] & [B3] & [B4]

Rob

 

[S Panja]

[A2]&", "&[B2]&", "&[B3]&" and "&[B4]
--
http://panjas.org
http://www.linkedin.com/in/spanja

If the reply is helpful or is the answer, click Yes next to
Was this post helpful to you?
and / or
Did this post answer the question?