Concatenate Field 2

[Jimmy2128]

I have the following scenario:

FullName:[FNAME] & " " & [MNAME] & " " & [LNAME] & " ," & [DESIGNATION]

I want to add a comma after LNAME when the members has DESIGNATION field but if the DESIGNATION field is blank do not use the comma.

Example:
John Doe, PHD
Marie Doe, (without the comma)

How can I do that...THanks

Jimmy

 

[THWatson]

Jimmy
Try this...

FullName:[FNAME] & " " & [MNAME] & " " & [LNAME] & IIf(IsNull([DESIGNATION]),"", " ," & [DESIGNATION])

Tom