Getting Extraneous rows in My crosstab report ???

[nbailey]

I have a multi query cross tab report where I am getting 1 row and 1 collumn of all zeros that should not be on the report.  Not sure where they are coming from or how to get rid of them.  Must be something to do with the way I am aggregating ???    See Attachment

[adam_mc]

Do you have a null year and a null xxCC Code (or whatever your column headings are) somehow coming into your query results?

Or, I think you can just "suppress" the additional row & column using the properties of the Crosstab.

Hope this helps.