IIF (If then else) help 2

[Bennie47250]

Using Access 2003

Need to write an if then else statement that will exclude 2 different codes and I can seem to get the syntax correct.

This works correctly, but it is only excluding the one HECODE of 29.

Expr1: IIf([PRTEMP2]![TCODE]="ERN" And [PRTEMP2]![HECODE]<>29,[PRTEMP2]![SUMHEAMT],0)

What I would like to do is exclude 2 different HECODE codes 20 and 29.

What would be the correct syntax for this?

Thanks
Bennie

 

[jrbarnett]

IIf([PRTEMP2]![TCODE]="ERN" And [PRTEMP2]![HECODE]<>29 AND [PRTEMP2]![HECODE]<>20,[PRTEMP2]![SUMHEAMT],0)

John

 

[Bennie47250]

That's it, thanks John!

 

[PHV]

Another way:
IIf(PRTEMP2.TCODE='ERN' AND PRTEMP2.HECODE Not In (29,20),PRTEMP2.SUMHEAMT,0)


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Bennie47250]

The "not in" was the syntax that I was trying to come up with, but could not get it correctly. Thanks PVH