Amin wrote:

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


Does this do what you want?

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

--
Marsh
MVP [MS Access]