Combining Fields

[RoadKill]

This is a stupid question, but I just can't seem to remember how to do it. I
want to combine the two fields of 'FirstName' & 'LastName' in one field named
'EmployeeName'. When I do it, it doesn't put a space in the name so it looks
like 'JohnDoe'. How do I get the space in between John and Doe? My sql is
below:

SELECT [FirstName]+[Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];

 

[Ken Snell \(MVP\)]

SELECT [FirstName] + ' ' + [Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];

 

[RoadKill]

I knew it was simple. Thanks much.

SELECT [FirstName] + ' ' + [Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];

--

Ken Snell
<MS ACCESS MVP>

This is a stupid question, but I just can't seem to remember how to do it.
I
want to combine the two fields of 'FirstName' & 'LastName' in one field
named
'EmployeeName'. When I do it, it doesn't put a space in the name so it
looks
like 'JohnDoe'. How do I get the space in between John and Doe? My sql is
below:

SELECT [FirstName]+[Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];

 

[Student Databaser]

I want to do this same thing, but have it automatically populate the Employee
field when last name and first name are entered in - not as a query, but in
the table.

Is this popssible? The reason for doing so is to be able to look up a
client by their whole name, not just first or last.

Thanks!

SELECT [FirstName] + ' ' + [Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];

--

Ken Snell
<MS ACCESS MVP>

This is a stupid question, but I just can't seem to remember how to do it.
I
want to combine the two fields of 'FirstName' & 'LastName' in one field
named
'EmployeeName'. When I do it, it doesn't put a space in the name so it
looks
like 'JohnDoe'. How do I get the space in between John and Doe? My sql is
below:

SELECT [FirstName]+[Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];

 

[Bob Barrows [MVP]]

I know this seems like a good idea to you but it's not. Storing the
results of the calculation forces someone to repeat the calculation
whenever one of the operands changes.

You will get more efficient results by indexing the last and first name
fields, and searching both of them for the names you want:

where lastname = [enter last name] and firstname = [enter first name]

I want to do this same thing, but have it automatically populate the
Employee field when last name and first name are entered in - not as
a query, but in the table.

Is this popssible? The reason for doing so is to be able to look up a
client by their whole name, not just first or last.

Thanks!

SELECT [FirstName] + ' ' + [Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];

--

Ken Snell
<MS ACCESS MVP>

This is a stupid question, but I just can't seem to remember how to
do it. I
want to combine the two fields of 'FirstName' & 'LastName' in one
field named
'EmployeeName'. When I do it, it doesn't put a space in the name so
it looks
like 'JohnDoe'. How do I get the space in between John and Doe? My
sql is below:

SELECT [FirstName]+[Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];