Conditional Characters (97)

Topic

New Reply

In furtherance of the question in my earlier post # 106447 where we discussed conditional characters… how can i now modify this statement to reflect that in the case where the title=”Member”, leave the title field blank and do not display the previous comma?
This is how it currently looks…

=Trim([FNAME] & ” ” & [LNAME] & IIf(IsNull([CRD])=True,””,”, “) & [CRD] & IIf(IsNull([Title])=True,””,”, “) & [TITLE])

Thanks : )

Reply | Quote

Replies

use:
=Trim([FNAME] & ” ” & [LNAME] & IIf(IsNull([CRD])=True,””,”, “) & [CRD] & IIf(IsNull([Title])=True OR [Title] = “Member”,””,”, ” & [TITLE]))

Reply | Quote

thanks francois… works like a charm…

Reply | Quote