cross tab query fill with zero

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
Thanks for helping,

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

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill Blanks with Zero on CrossTab 4
crosstab query child table count 5
crosstab query 3
dcount in a crosstab query 3
Crosstab queries, <> and null values 3
MISSING ZEROS IN A QUERY 4
Nulls in Crosstab queries 2
Crosstab queries - populating blanks with zeros 3

Back
Top