Expressions
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])
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"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]))
i want to store the names with the title first
|