wildcard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get this to equal 0.5 if the field has a D in it and 1.0 if the
field only has a D?

Something like this:?

DDQTY: IIf([DQty]="D","1")

or

DDQTY: IIf([DQty]="*D*","0.5") ----> I don't think I have this line right?

Thanks for the help.
-Joel
 
Is Dqty a number field or a text field? I'll guess number since it looks like
it may be quantity. Also, what do you want if there is no "D" at all? I guessed
0 (zero).

DDQty: IIF(Dqty="D",1,IIF(Dqty LIKE "*D*",.5,0))
 
Back
Top