Trimming brackets in criteria if nothing to go between them

[Diana van den Berg]

Attendee: Trim([Surname] & ", " & [FirstName] & IIf([Visitor?]="Yes"," (Visitor)","")) & IIf([Rank]="",""," " & Trim([Rank]))

I have the above criteria in a query, to produce atttendees of a meeting. If the field Visitor is Yes, then the word Visitor appears after the FirstName in brackets. If the attendee is a member of the police, then the rank appears after the FirstName. I would like the rank to appear in brackets. However, I don't want the brackets showing if there is nothing in the Rank field. I have tried several things with Trim, but each time I have got an empty pair of brackets, thus, () appearing after all the FirstNames. Please tell me how to get them to display only if there is something in the Rank field.

Thank you in anticipation.

[HansV]

Try

Attendee: Trim([Surname] & ", " & [FirstName] & IIf([Visitor?]="Yes"," (Visitor)","")) & IIf([Rank] Is Null,""," (" & Trim([Rank]) & ")")

[Diana van den Berg]

Perfect!!!

Thank you Hans!