Query count formula not counting blanks

[randolphoralph]

I have a query which I am trying to count the records that has a Date equal to 99999999 and Area equal to 01, 02, PR, and blanks.



I tried the following but am only getting a count of the records that have Date equal to 99999999 and Area equal to 01, 02, PR

All Others: Count(IIf([Date]="9999999" And [Area] In ("01","02, "PR","",Null),0))

What am I missing?

[June7]

Appear to be missing a 9 in the Count expression.

All Others: Count(IIf([Date]="99999999" And Nz([Area],"XXX") In ("01", "02, "PR", "", "XXX"),0))

or

All Others: Count(IIf([Date]="99999999" And IIf([Area] Is Null, "XXX", [Area]) In ("01", "02, "PR", "", "XXX"),0))

[randolphoralph]

June7 thank you. Your solution worked perfectly. The missing 9 was my fault as I typed one too many in my post.