Cross tab queries

[kwagner1]

1 - In the crosstab table example below how would I remove the #Name (from CrossTabB)? This occurred because there was data matching the selection criteria and now there is not. I would like to make a 0 show up. I am using a cross tab query.
A related question which may have the same answer….

2 - Also, in the example below the first column (Submit column) in the last table (Crosstab C) is not displaying (i put the word "blank" to identify it for you - i want a "0") because there is not and never has been data for that combination of values. How can I force a zero so that column would contain all zeros?

Thanks again for all your help!!
(apologies about the layout of my data, but i dont have access to post an image for you


CrosstabA Submit Analyse Test Total
ML 2 1 3 6
TF 0 1 3 4

CrosstabB Submit Analyse Test Total
URGENT #Name? 1 4 5
HIGH #Name? 2 2 4
LOW #Name? 8 0 8

CrosstabC blank Analyse Test Total
GPCx blank 6 1 7
GPCy blank 2 3 5

 

[Andrew Fergus]

Hi
Have a read of this article. I suspect that you modified the query or an underlying table such that the problem field name in the 2nd crosstab query is incorrect.
HTH, Andrew

 

[kwagner1]

thanks Andrew... i'll check this out tomorrow. Thanks for the link!