Help: Query Criteria 2

[ddmtn546]

OPC: IIf([Resupplied]="Yes",0,+[1IntMW]-[Integrated])

The above criteria assign's a 0 to the OPC range if the value in the range "Resupplied" is equal to Yes. Else, subtract Integrated from 1IntMW.
There are 4 choices in the drop down box: Yes, No, Unknown & Wheel.
Question? How do I also cause the expression to recognize and assign a 0 for all choices, except No?

Thanx in advance.

 

[THWatson]

Try this...
IIf(([Resupplied]="Yes") Or ([Resupplied]="Unknown") Or ([Resupplied]="Wheel"),0,+[1IntMW]-[Integrated])

You could also try it the other way around...
IIf([Resupplied]="No",+[1IntMW]-[Integrated],0)

I'm not clear why you have the + in the expression, however you will know.

Tom

 

[TheAceMan1]

How are ya ddmtn546 . . . .

[blue]OPC: IIf([Resupplied]="No",[purple]ValueForNo?[/purple],0)[/blue]

See Ya! . . . . . .