IIf added condition creating dups...

[daniela]

I am using the following criteria to test if an order is Current. The problem I'm having is that I am getting duplicates. Ex. If an order is Current it can't be "Repair"

This worked fine until I added one more condition: [supplier_status]='55'

Any suggestions??? Thanks!


Current: IIf([supplier_status]='55' Or (nz([dayslate],0)<=0 And [cancelled]=0 And [delivered]=0 And [repair]=0 And [SNRCurrent]=0 And [SNRpastdue]=0 And [rejectedCurrent]=0 And [AwaitingDcccur]=0),1,0)

 

[llkhoutx]

Question, what does

[supplier_status]='55'

represent, a numeric or string test?

If a string, try using "55", if numeric use 55.

It looks like your trying to test if [supplier_status]=?? OR the results of the other fields test True.

It's not clear to me where it's being used.

Just my thoughts.