Expression builder help

[Nymandus]

I need some logic help,

I am trying to sum fields if a another field (Accurate/Complete (30 pts)) is less than 30


Right now it works to provide my total if the yes/no button for a certain field has been clicked.
=Sum(IIf([Procedure Error],1,0))

now I want it to only total the numbers if
[Accurate/Complete (30 pts)]<30

I know there has to be a simple concatinate but my brian is not getting me there....

so how would I add the if less than to the top expression?


any help would be greatly appreciated.

 

[pbaldy]

With "And":

=Sum(IIf([Procedure Error] And [Accurate/Complete (30 pts)]<30,1,0))

 

[Nymandus]

You rock...
thank you.

I was trying to put the [Accurate/Complete (30 pts)]<30 first... :banghead:

 

[pbaldy]

Happy to help! Should work either way, as long as they're separated by And.