IIF statement giving me a fit

[kalebson]

I am trying to get this statement to calculate based on 3 parameters:

CallsAbandoned1: IIf([dbo_dApplicationStat_PHX].[Application]<>"DI_CF_App" Or "DI_IBank_App" Or "DI_Met_App",(([dbo_dApplicationStat_PHX].[CallsAbandoned])-(([AbdDelay2])+([AbdDelay4])+([AbdDelay6])+([AbdDelay8])+([AbdDelay10]))),(([dbo_dApplicationStat_PHX].[CallsAbandoned])-(([AbdDelay2])+([AbdDelay4])+([AbdDelay6])+([AbdDelay8])+([AbdDelay10])+([AbdDelay12])+([AbdDelay14])+([AbdDelay16])+([AbdDelay18])+([AbdDelay20])))

However I get the same result that I get w/o the

(([dbo_dApplicationStat_PHX].[CallsAbandoned])-(([AbdDelay2])+([AbdDelay4])+([AbdDelay6])+([AbdDelay8])+([AbdDelay10])+([AbdDelay12])+([AbdDelay14])+([AbdDelay16])+([AbdDelay18])+([AbdDelay20])))

Am I missing a comma or parenthesis in the wrong place? TIA.

 

[PHV]

Replace this:
([dbo_dApplicationStat_PHX].[Application]<>"DI_CF_App" Or "DI_IBank_App" Or "DI_Met_App",
with either this:
([dbo_dApplicationStat_PHX].[Application] Not In ("DI_CF_App","DI_IBank_App","DI_Met_App"),
or this:
([dbo_dApplicationStat_PHX].[Application]<>"DI_CF_App" Or [dbo_dApplicationStat_PHX].[Application]<>"DI_IBank_App" Or [dbo_dApplicationStat_PHX].[Application]<>"DI_Met_App",

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

Try the NOT IN statement instead of stringing together ORs

CallsAbandoned1: IIf([dbo_dApplicationStat_PHX].[Application] NOT IN("DI_CF_App","DI_IBank_App", "DI_Met_App"),
(([dbo_dApplicationStat_PHX].[CallsAbandoned])-(([AbdDelay2])+([AbdDelay4])+([AbdDelay6])+([AbdDelay8])+([AbdDelay10]))),(([dbo_dApplicationStat_PHX].[CallsAbandoned])-(([AbdDelay2])+([AbdDelay4])+([AbdDelay6])+([AbdDelay8])+([AbdDelay10])+([AbdDelay12])+([AbdDelay14])+([AbdDelay16])+([AbdDelay18])+([AbdDelay20])))

If you want to string together ORs the syntax will be:

CallsAbandoned1: IIf([dbo_dApplicationStat_PHX].[Application]<>"DI_CF_App" Or [dbo_dApplicationStat_PHX].[Application]<>"DI_IBank_App" Or [dbo_dApplicationStat_PHX].[Application]<>"DI_Met_App",(([dbo_dApplicationStat_PHX].[CallsAbandoned])-(([AbdDelay2])+([AbdDelay4])+([AbdDelay6])+([AbdDelay8])+([AbdDelay10]))),(([dbo_dApplicationStat_PHX].[CallsAbandoned])-(([AbdDelay2])+([AbdDelay4])+([AbdDelay6])+([AbdDelay8])+([AbdDelay10])+([AbdDelay12])+([AbdDelay14])+([AbdDelay16])+([AbdDelay18])+([AbdDelay20])))

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[PHV]

OOps, wrong logic:
or this:
([dbo_dApplicationStat_PHX].[Application]<>"DI_CF_App" And [dbo_dApplicationStat_PHX].[Application]<>"DI_IBank_App" And [dbo_dApplicationStat_PHX].[Application]<>"DI_Met_App",

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kalebson]

Perfecto Mundo..Thx a million guys.

 

[lespaul]

got us both!!!

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[VicRauch]

Of course I'm not sure what you want your IF statement to be, but this is what it is:

If Application is unequal to DI_CF_APP
OR
If DI_IBank_App is True
OR
If DI_Met_App is True,

Then ...

I will assume that you want to check DI_CF_APP AND DI_Bank_App AND DI_Met_App against Application. And, if you want each of them to be UNEQUAL to Application, then you will need AND between each test for UNEQUAL. With the AND, you are making sure that ALL three comparisons to Application are UNEQUAL.

If I have guessed wrong about your IF, let me know and I will look further.

HTH,
Vic

 

[kalebson]

I even screen shotted this post cuz I know im gonna do it again later hehe..thx again