You'll need to do an "iif" statement... FullName: =iif([Client_Mname] is null, [Client_Lname]&", "& [Client_Fname], [Client_Lname]&", "&[Client_Mname]&" "& [Client_Fname])
--- In [email protected], "Isaiah Vi" <[EMAIL PROTECTED]> wrote: > > I currently have a query that concatenates the last first and middle names of a client into one column. My expression is here below: > > =[Client_Lname] & ", " &[Client_Mname &" " & [Client_Fname] > > This expression works great if there is actually a middle name for a client (ie. Doe, Mary Jane). However, if the client does not have a middle name, it will display an extra space character after the comma "," (ie. Doe, Jane). What is the correct expression to get rid of the extra space if there is no middle name for a client? > > TIA, > Izzy > > > [Non-text portions of this message have been removed] >
