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.