Thread: Expressions
View Single Post
  #1  
Old April 29th, 2010, 12:03 PM posted to microsoft.public.access.queries
Amin
external usenet poster
 
Posts: 181
Default Expressions

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