Criteria problem

[evanhughes]

How do I change the following criteria.
Charge: IIf([UnitCode]="P005",25,55)

I need to apply this criteria only if it is not equal to

[field5] is not equal to "can" and if it is equal to can then value will be 0.

Can't get my head around it.

Evan

 

[cjcobra]

=IIF([UnitCode]<>

.[field5],"can",0)

 

[Brianwarnock]

How do I change the following criteria.
Charge: IIf([UnitCode]="P005",25,55)

I need to apply this criteria only if it is not equal to

[field5] is not equal to "can" and if it is equal to can then value will be 0.

Can't get my head around it.

Evan

And I can't get my head round this sentence

I need to apply this criteria only if it is not equal to

[field5] is not equal to "can" and if it is equal to can then value will be 0.

Please rewrite .

Brian


I suspect that you are after something like

Charge: IIf([field5]="can",0,IIf([UnitCode]="P005",25,55))