concatination

[Richard]

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

 

[Lynn Trapp]

For the format Last Name, First Name do this:

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

For the format First Name Last Name do this:

= [FirstName] & " " & [LastName]

 

[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