Blank Field in Cross Tab Query

B

Bart

I have a cross tab query look like this

Total Open In-Progress Closed
Support A 4 2 2
Support B 3 3
Support C 4 2 2
Support D 1 1

I want to put zero in blank field, because if not, they will not reflect on
my graph. For example, I want to be the value of "Closed" for "Support A" to
be "0" instead of blank. Is this possible
 

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

How to display zero value in blank fields of Cross Tab query 0
Field Does Not Appear in Cross Tab 1
How to Create an S-Curve from Custom Field? 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0
Parameter in Row does not appear if no value 2
Finding the right style field in VBA 0
Missing Row Field in Crosstab Query 1

Top