debbiecarvery
MIS
Hello,
Jim and bob helped me out with this statement but now I would like to add something, and again it is not working, perhaps someone can help .
The Total VC area works, I want these numbers 12, 14 or 16 to print only if Equipe equals "no", I have also tried putting the [equipe] = "no" at the beginning of my statement.
=(IIf([Sum of Total VC] Between 550 And 599,12,IIf([Sum of total VC] Between 600 And 649,14,IIf([sum of total vc]>=650,16,0)))) And [Equipe]="no"
Thanks,
Debbie
Jim and bob helped me out with this statement but now I would like to add something, and again it is not working, perhaps someone can help .
The Total VC area works, I want these numbers 12, 14 or 16 to print only if Equipe equals "no", I have also tried putting the [equipe] = "no" at the beginning of my statement.
=(IIf([Sum of Total VC] Between 550 And 599,12,IIf([Sum of total VC] Between 600 And 649,14,IIf([sum of total vc]>=650,16,0)))) And [Equipe]="no"
Thanks,
Debbie