concatination

R

Richard

I'm having difficulty concatinating two fields in a
table. Any Ideas? I just want to combine the LastName
field and FirstName field.
 
L

Lynn Trapp

For the format Last Name, First Name do this:

=[LastName] & ", " & [FirstName]

For the format First Name Last Name do this:

= [FirstName] & " " & [LastName]
 
P

Pieter Wijnen

select LastName & ", " & FirstName AS FullName FROM YourTable
Hint: Use Shift+F2 in the QBE (desgin View) and Type:
FullName:LastName & ", " & FirstName

HTH

Pieter
 
Top