|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 4th, 2008, 11:14 AM
posted to microsoft.public.access
|
|||
|
|||
Adding text in seperate coulumns to be joined in a single column
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? 
|
|
#2
November 4th, 2008, 12:16 PM
posted to microsoft.public.access
|
|||
|
|||
|
Adding text in seperate coulumns to be joined in a single column
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?
|
|
#3
November 4th, 2008, 06:42 PM
posted to microsoft.public.access
|
|||
|
|||
|
Adding text in seperate coulumns to be joined in a single column
[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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
