Omit Comma (1 Viewer)

Lily

Registered User.
Local time
Today, 23:45
Joined
Oct 1, 2000
Messages
42
Hello,

I used an expression in a query to join the first name and last name fields separated by a comma and then the title...as follows:

Name: [First Name] & " " & [Last Name] & ", " & [Title]

However, how do I get it to omit the comma if there is no title for a particular person. Thank you very much for your help, it is much appreciated.
 

R. Hicks

AWF VIP
Local time
Today, 18:45
Joined
Dec 23, 1999
Messages
619
Try this:

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

HTH
RDH
 

Lily

Registered User.
Local time
Today, 23:45
Joined
Oct 1, 2000
Messages
42
RDH,

Thank you so much again!! It works perfectly, and I thank you for your help.
 

Users who are viewing this thread

Top Bottom