Sum IIf and three variables

[ralphyehle]

I want to create a field named ErrorCases that sums the rows meeting the following conditions: The row has a ValidityReason = 2 and for the same row ExpValidity is either null or 3. I want a count of the rows meeting these condtions.

Here is the formula I have constructed that does not work.

ErrorCases: Sum(IIf(([ValidityReason]="2" And [ExpValidity] Is Null) Or ([ValidityReason]="2" And [ExpValidity]="3"),1,0))

Any suggestions?

 

[Bat17]

duplicate post

 

[Vassago]

Answered here:

http://access-programmers.co.uk/forums/showthread.php?t=103254