IIf, AND, OR

[spg2112]

Hey all,

What's wrong with this formula? This is driving me bonkers!

IIf ( ( ( [dbo_rpt_FT]![CIS_DIVISION] = "AE-TX") And ( [dbo_rpt_FT]![CUST_CL_CD] = ( "AE LOW" Or "AE RES" Or "MM LOW" Or "MM RES" Or "MMRESNLP" ) ) , "POLR RES",””)

Steve

 

[Joe4]

You cannot use the OR statement like that in just the equals portion. You need to test each formula separately. The OR portion of your statement should look like:

(([dbo_rpt_FT]![CUST_CL_CD] = "AE LOW") Or ([dbo_rpt_FT]![CUST_CL_CD] ="AE RES") Or ([dbo_rpt_FT]![CUST_CL_CD] ="MM LOW") Or ((dbo_rpt_FT]![CUST_CL_CD] ="MM RES") Or ([dbo_rpt_FT]![CUST_CL_CD] ="MMRESNLP" ))

 

[spg2112]

Thanks! That will work.

Steve