Joining First and last name

[Peggy]

I can combine the fields "LastName" and "FirstName" into
one "Name" but the names are stuck together with no space.
Is there an operator I should be putting in the query when
I do this?

 

[Cheryl Fischer]

Hello Peggy,

I presume you are doing something like this:

[LastName] & [FirstName]

Try it this way:

[LastName] & " " & [FirstName]

hth,