Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Characters (97)

    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 : )

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Characters (97)

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

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Characters (97)

    thanks francois... works like a charm...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •