How to combine 2 data columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a table containing Employee ID, Last Name, and First Name columns. I
want to query the data so that I just get the last name and first name in a
single column. So if I have an employee with Last Name "Smith" and First
Name "John", I want "John Smith" returned from the query.

Can I do this with Access or SQL?
 
simsjr said:
-----Original Message-----
Hello,

I have a table containing Employee ID, Last Name, and First Name columns. I
want to query the data so that I just get the last name and first name in a
single column. So if I have an employee with Last Name "Smith" and First
Name "John", I want "John Smith" returned from the query.

Can I do this with Access or SQL?
.
Click to expand...

Hi simsjr,

create a query with the table as its data source. In a
blank column field row type:
[first name] & " " & [last name]

Luck
Jonathan
 
Back
Top