Joining First and last name

P

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

Cheryl Fischer

Hello Peggy,

I presume you are doing something like this:

[LastName] & [FirstName]

Try it this way:

[LastName] & " " & [FirstName]

hth,
 
Top