Expression problem

[dpav29]

What's wrong with this expression?

"Mailed-MD/DO": Sum(IIf([providers!degree]="MD" Or [providers!degree]="DO" And [credentials]![MailDate] Is Not Null,1,0))

The MailDate is not null part isn't working. No errors, it is just being ignored. Any thoughts?

 

[burgess1975]

Here's what you want:

"Mailed-MD/DO": Sum(IIf([providers!degree]="MD" Or [providers!degree]="DO" And IsNull([credentials]![MailDate])=False,1,0))

In Access, use IsNull(Expression) instead of Expression Is Not Null.

-Jeff Burgess