ms access 2007 combining a multi-valued field with a single-value field in query

Question

In Access 2007 I have a table with a column with a single-value field and a column with multi-valued field. Now I want to combine the values of these two columns in a new column in a query:

example:

the situation:
table 1              
column 1       column 2
1              2;3;6
2              1;4;7
4              3;1;2

what I wish to acomplish:
query
column n
1;2;3;6
2;1;4;7
4;3;1;2

thank you in advance for your help

Answer 1

here is the sql that can acomplish your results

 Select column1 & ";" & column2 from table1

Answer 2

SELECT column1 & ";" & column2 FROM table1;