Concatenate in Access

[sathsaj]

HI


Is there a solution in Access for the below data


Name
Oliver
Markus

Required Result in the next Column = Oliver;Markus

 

[theDBguy]

Hi. Maybe something like this?

 

[The_Doc_Man]

The way to do this is to use the concatenation operator "&" (a.k.a. ampersand).

In VBA: X = A & B (or, since you want punctuation) X = A & ";" & B

In SQL: SELECT ...., A & ";" & B As LongName, ... FROM ....

(where the AS clause is merely an alias for the field).

That looks like it came from a spreadsheet, which would be fine. Just watch out for use of the word "NAME" as a potential field name. It happens that it is an Access reserved word and can cause confusion if you are not very careful.

 

[sathsaj]

am not from IT background, so unable to get the results :-(

The way to do this is to use the concatenation operator "&" (a.k.a. ampersand).

In VBA: X = A & B (or, since you want punctuation) X = A & ";" & B

In SQL: SELECT ...., A & ";" & B As LongName, ... FROM ....

(where the AS clause is merely an alias for the field).

That looks like it came from a spreadsheet, which would be fine. Just watch out for use of the word "NAME" as a potential field name. It happens that it is an Access reserved word and can cause confusion if you are not very careful.

 

[theDBguy]

am not from IT background, so unable to get the results :-(

Do you know how to create a query of your table? If you have one, can you post the SQL statement of your query? Thanks.

 

[Mark_]

Are you working with different fields in the same record OR are you working with the same field in different records?

Concatenation is used when you put together different fields in the same record. It is also used when you want to put together text from different controls on a screen.