Cross tab queries

kwagner1

Active Member
Joined
Jun 10, 2003
Messages
445
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,649
Members
412,335
Latest member
cinciri99
Top