Help with a formula

J

Jeanette

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!!!
 
R

Rick Brandt

Jeanette said:
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!!!
Click to expand...

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

Jeanette

Rick:

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

Have a GREAT day.

Rick Brandt said:
Jeanette said:
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!!!
Click to expand...

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)
Click to expand...
 
Top