How to combine 2 data columns?

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

 

[Jonathan Parminter]

-----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?
.

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