Concatenate in Access (1 Viewer)

sathsaj

Registered User.
Local time
Today, 02:53
Joined
Sep 19, 2017
Messages
24
HI


Is there a solution in Access for the below data


Name
Oliver
Markus

Required Result in the next Column = Oliver;Markus
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 04:53
Joined
Feb 28, 2001
Messages
26,996
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

Registered User.
Local time
Today, 02:53
Joined
Sep 19, 2017
Messages
24
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

I’m here to help
Staff member
Local time
Today, 02:53
Joined
Oct 29, 2018
Messages
21,357
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_

Longboard on the internet
Local time
Today, 02:53
Joined
Sep 12, 2017
Messages
2,111
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.
 

Users who are viewing this thread

Top Bottom