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?

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

Rob


Mark909 wrote:
> 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?

[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?


"Mark909" wrote:

> 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?