How to concatenate fields

[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
Aparna

[June7]

Maybe like:

SELECT ID & Centre AS ID_Ctr FROM tablename;

If you want more specific guidance, provide names of things (table and fields). An example of the desired output would be helpful.

If you want to provide db for analysis, follow instructions at bottom of my post.