Thread: Expressions
View Single Post
  #2  
Old April 29th, 2010, 04:33 PM posted to microsoft.public.access.queries
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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