I am using a crosstab query and want 0's when no data is present

[Jerri]

I am using a crosstab query where the column heading is the months of the
year totals. When there is no data for that model during a month, I would
like a zero to be placed in the column. How is that done?

Thanks

 

[Douglas J. Steele]

Try using the Nz() function around whatever field's being displayed.