Expressions

[Amin]

i want to write an expressions to concatenate these three things,

Title,Last Name, First Name
Contact Name: IIf(IsNull([Last Name]),IIf(IsNull([First
Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First
Name] & " " & [Last Name]))

i want to store the names with the title first

 

[Jerry Whittle]

I think that you are making it too difficult. Also I don't see Title but do
see Company. Anyway try something like this instead:

Contact Name: Trim([Title] & " " & [First Name] & " " & [Last Name])