how to concatenate two columns in access

[aparnawangu]

Hi Team,
Currently i am working on a student database in access.I have a requirement where i have to write a query with combination of two columns in access and that too one number field and one text field.
Eg:One column contains student id like 1,2,3,4,5 etc and second column contains centre names like w1,w2,w3,w4,w5 etc.
Problem is that same student ids can get repeated across diffrent centres like 1,w1 and 1,w2

As student id is not unique and it will be repeated across all the centres.Pls suggest how to write the query

Thanks in advance
Aparna

 

[MarkK]

The query can look like . . .

SELECT StudentID & " " & CentreName As NewJoinedField
FROM YourTable

. . . and as far as that query goes, it doesn't matter that the student ID is not unique per centre. Or if you want only unique rows, you can do . . .

SELECT DISTINCT StudentID & " " & CentreName As NewJoinedField
FROM YourTable

 

[Galaxiom]

Using the example data you have provided, what do you want as the output?