Column Headings in a cross tab query

J

Jerri

The following message was given to be able to display zero's in a query when
there are no records for the given month. Could someone explain to me
farther how to use the instructions below.

Thanks

Exception is if your query is a crosstab query with months being the columns
produced byt the crosstab. Then you can use the ColumnHeadings property to
force the display of all desired columns even if the data does not include
records for every column being produced.
 

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
Cross tab query solution 4
Columns using month and year 1
Crosstab query with changing column headings 5
Column Heading on Crosstab Query 5
Cross-Tab Query Question 1
How do I set the ColumnHeadings property? 4
Sub report based on Crosstab query 4

Top