query Nested IIf statement 2

[BrockLanders]

Hi, I have a query with a nested IIf statement that is not working correctly. The problem is happening in my final else statement. I'm getting values returned, but not the correct values. Below is my statement:

Sum(IIf([Chain]="1_data",([Current EVDY Net]*2),IIf([Chain]="4_data" Or "5_data" Or "6_data" Or "7_data",([Current EVDY Gross]*0.9),[Current EVDY Net]))) AS [EVDY Net]

For a Chain that is not listed above, which are chains 2_data and 3_data, I'm getting the wrong numbers. So if Chain is equal to 2_data or 3_data the result should just be the value in [Current EVDY Net] field and not a calucation like the other chains.

Any ideas?

 

[dhookom]

Try add [Chain]= for each condition like:

Sum(IIf([Chain]="1_data",([Current EVDY Net]*2),IIf([Chain]="4_data" Or [Chain]="5_data" Or [Chain]="6_data" Or [Chain]="7_data",([Current EVDY Gross]*0.9),[Current EVDY Net]))) AS [EVDY Net]


Duane
MS Access MVP

 

[tvett]

you need to repeat the [chain]= so that it reads :-

Sum(IIf([Chain]="1_data",([Current EVDY Net]*2),IIf([Chain]="4_data" Or [chain]="5_data" Or [chain]="6_data" Or [chain]="7_data",([Current EVDY Gross]*0.9),[Current EVDY Net]))) AS [EVDY Net]

 

[BrockLanders]

yep, that's what it was. thanks dhookom and tvett!