What's wrong with this Criteria

[djclntn]

AFC_DIVW: IIf([HDiv]="AFC-E" And [HDiv]="AFC-N" And [HDiv]="AFC-
S" And [HDiv]="AFC-W" And [HResults]="L",1,0)

I have the following fields & data :
[HDiv] can contain data as, “AFC-E” “AFC-N” “AFC-S” “AFC-W” “NFC-E” “NFC-N” “NFC-S” & “NFC-W”

[HResutls] “W”, “L”

[AFC_DIVW] IIf([HDiv]="AFC-E" And [HDiv]="AFC-N" And [HDiv]="AFC-
S" And [HDiv]="AFC-W" And [HResults]="L",1,0)

[June7]

No record can meet the criteria. No record will have all those values in HDiv field.

Try OR instead of AND and parens around the OR terms.

AFC_DIVW: IIf(([HDiv]="AFC-E" Or [HDiv]="AFC-N" Or [HDiv]="AFC-S" Or[HDiv]="AFC-W") And [HResults]="L",1,0)

[djclntn]

Hi, thanks for responding. The expression you sent me worked, but wasn’t what I anticipated. There’s another fld within the query which is involved. Please allow me to elaborate further on the fields above,

[COLOR="#0000FF"] [RConf] “AFC” Or “NFC”
[RDiv] “AFC-E” ”AFC-N” ”AFC-S” ”AFC-W ”NFC-E” etc.
[HResutls] “W”, “L”

- AFC_CFW: IIf([RConf]="AFC" And [HConf]="AFC" And [HResults]="W",1,0) “#ERROR” appears in Dataset View

- AFC_CFW: IIf([RConf]="AFC" Or [HConf]="AFC" And [HResults]="W",1,0) “#ERROR” appears in Dataset View

[June7]

You don't show HConf as one of the 3 fields listed above the expressions. If that fields does not exist, that could result in the #ERROR.