Concatenation

[Confused]

I do not understand the instructions for concatenation.

The help file states to join two name by doing the following:
"if you have a table that contains the fields FirstName and LastName, you
can use the following expression to create a text string that displays the
values of the FirstName and LastName fields separated by a space.
[FirstName] & " " & [LastName]"

I have a query of a table that currently returns first name and last name
and some other fields. If I want the query to concatenate the first and last
names, I need to use [FirstName] & " " & [LastName]".

I can get to the SQL area, but how do I modify the following to concatenate
the names? Each attempt I have made has not produced the result I desired.

SELECT Table.Firstname, Table.Lastname, Table.AnotherField
FROM Table
WHERE (((Table.AnotherField)=[Which?]) AND ((Table.YetAnotherField)="yes"))
ORDER BY Table.Lastname;

I am fine losing the individual Firstname and lastname fields; I am fine
keeping them in the query too as long as I get the names concatenated somehow.

I appreciate the help.

 

[Confused]

I finally figured this out.

Duh.