Joining First and last name

  • Thread starter Thread starter Peggy
  • Start date Start date
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?
 
Hello Peggy,

I presume you are doing something like this:

[LastName] & [FirstName]

Try it this way:

[LastName] & " " & [FirstName]

hth,
 
Back
Top