cross tab query fill with zero

[Souris]

I have a crosstab query for the report.
It fiills blank when zero counts.
Is it possible to make crosstab query to fill zero when zero counts?

Your information is great appreciated,

 

[KARL DEWEY]

Post the SQL of the crosstab query.

 

[Souris]

Thanks for helping,

I uses iif(isnull(count(MyField)), 0, count(Myfield)) to fix the issue.

Thanks,

 

[KARL DEWEY]

Did that fix it?
If not then post the SQL of the crosstab query.