Help with a formula

[Guest]

I have the following expression in my query:

Expr2: IIf([SCHW ADV NETWORK - New]="Yes",[TOTAL FEE]-0)

The choice is now not only "Yes" but "Yes - New" and I want the same thing
to happen for either choice TOTAL FEE - 0. How do I add this to the
existing formula?

Any help would be greatly appreciated!!!

 

[Rick Brandt]

I have the following expression in my query:

Expr2: IIf([SCHW ADV NETWORK - New]="Yes",[TOTAL FEE]-0)

The choice is now not only "Yes" but "Yes - New" and I want the same
thing to happen for either choice TOTAL FEE - 0. How do I add
this to the existing formula?

Any help would be greatly appreciated!!!

Expr2: IIf([SCHW ADV NETWORK - New] In("Yes", "Yes - New"),[TOTAL FEE]-0)

or

Expr2: IIf([SCHW ADV NETWORK - New] Like "Yes*",[TOTAL FEE]-0)

 

[Guest]

Rick:

The second one you suggested worked for me. Thank you so much for your help!

Have a GREAT day.

I have the following expression in my query:

Expr2: IIf([SCHW ADV NETWORK - New]="Yes",[TOTAL FEE]-0)

The choice is now not only "Yes" but "Yes - New" and I want the same
thing to happen for either choice TOTAL FEE - 0. How do I add
this to the existing formula?

Any help would be greatly appreciated!!!

Expr2: IIf([SCHW ADV NETWORK - New] In("Yes", "Yes - New"),[TOTAL FEE]-0)

or

Expr2: IIf([SCHW ADV NETWORK - New] Like "Yes*",[TOTAL FEE]-0)