Query - Merging Fields

[Guest]

I am new to access and need some help. I have a table with employees and I
have a field FirstName and LastName.

I am trying to do a query where there is one field with the first and last
name in the same field. I have done the following:

Tech: [FirstName]+[LastName]

When I run my query it does show the first and last name but there is no
space between the two. How can I get a space between the first and last name?

Thanks.

 

[Guest]

Try
[FirstName]&" "&[LastName]
or
[LastName]&", "&[FirstName]

Hope this helps.

 

[Guest]

Thank you - this worked!!

Try
[FirstName]&" "&[LastName]
or
[LastName]&", "&[FirstName]

Hope this helps.

I am new to access and need some help. I have a table with employees and I
have a field FirstName and LastName.

I am trying to do a query where there is one field with the first and last
name in the same field. I have done the following:

Tech: [FirstName]+[LastName]

When I run my query it does show the first and last name but there is no
space between the two. How can I get a space between the first and last name?

Thanks.