Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have the following:

    Rating2: IIf([COPRM_C] In (14,27),"ASO/ASC") & IIf([COPRM_C] In (32,3),"Cost Plus") & "Insured"

    This does not work correctly. I want anything other than 14,27,32,3 to be Insured. What is the proper syntax for this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Does this do what you want?

    Rating2: IIf([COPRM_C] In (14,27), "ASO/ASC", IIf([COPRM_C] In (32,3), "Cost Plus", "Insured"))

Posting Permissions

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