Expressions

  • Thread starter Thread starter Amin
  • Start date Start date
A

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
 
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])
 
Back
Top