Please help in SQL Server or MS Access?

Question

I have two fields in one table. I want to concatenate the two fields and I want that after concatenation, third field will automatically be generated through query. Please help me.

Answer 1

suppoise you have an employee table with two fields say:name and age

you can write this query for your question:

select name,age,name||age

from employee

Hope this works!

Answer 2

In SQL Server:

select col1, col2, col1+col2 from tab_name

In Access:

select col1, col2, col1 & col2 from tab_name