Count IIf statement error

[Huddle]

I am getting an error on the following count iif statement. Can you see what the problem is?



=Count(IIf([Schedule_Status]<>"Unscheduled",IIf([Schedule_Status]<>"In AC Review",IIf([Schedule_Status]<>"In DC Review",IIf([Schedule_Status]<>"In LESPM Review",IIf([Schedule_Status]<>"Returned for Rework",IIf([Schedule_Status]<>"Fnal - Mist",IIf([Schedule_Status]<>"Waiver",IIf([Schedule_Status]<>"FSC Completed",IIf([District]="D1",0))))))))))

[June7]

What is the exact error?

I don't understand what you want. What rule are you trying to enforce - Don't count any records with any of those values?

[Huddle]

Yes. I want to count all the records for D1 except those that are Unscheduled, In AC Review, In DC Review, in LESPM Review, Returned for Rework, Final - MIST, Waiver or FSC Completed.

[June7]

Then I don't see need for nested IIf

=Count(IIf([Schedule_Status]<>"Unscheduled" AND [Schedule_Status]<>"In AC Review" AND [Schedule_Status]<>"In DC Review" AND [Schedule_Status]<>"In LESPM Review" AND [Schedule_Status]<>"Returned for Rework" AND [Schedule_Status]<>"Fnal - Mist" AND [Schedule_Status]<>"Waiver" AND [Schedule_Status]<>"FSC Completed" AND [District]="D1", [District]))

or

=Sum(IIf([Schedule_Status]<>"Unscheduled" AND [Schedule_Status]<>"In AC Review" AND [Schedule_Status]<>"In DC Review" AND [Schedule_Status]<>"In LESPM Review" AND [Schedule_Status]<>"Returned for Rework" AND [Schedule_Status]<>"Fnal - Mist" AND [Schedule_Status]<>"Waiver" AND [Schedule_Status]<>"FSC Completed" AND [District]="D1", 1, 0))

[Huddle]

Still giving me a #Error. What causes a #Error?

[June7]

I this case, I expect it means a reference in the expression can't be found. Are all those field names included in the form RecordSource? Are they spelled correctly?

If you want to provide db for review, follow instructions at bottom of my post.

[Huddle]

I found the one part of the expression that was causing the error and deleted it. The formula you gave would work. I will close the post.