The only problem with code like:
Code:
FullName1: Trim(Nz(c.Title,"") & " " & Trim(Nz(c.FirstName,"") & " " & Nz(cLastName,"")))
is that you get unwanted spaces if the title or first name fields are blank
The following isn't quite as neat but solves that issue:
Code:
FullName2: IIf(Nz([Title],"")<>"",[Title] & " ","") & IIf(Nz([FirstName],"")<>"",[FirstName] & " ","") & IIf(Nz([LastName],"")<>"",[LastName] & " ","")
I've allowed for missing last names above though this could just be
Code:
FullName3: IIf(Nz([Title],"")<>"",[Title] & " ","") & IIf(Nz([FirstName],"")<>"",[FirstName] & " ","") & [LastName]
Example results: