Crosstab column header question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I create a crosstab that is used for monthly totals and is based off the
completed date. The query shows only the columns header for months that are
populated. There are time that we will have some future orders and have to
populate the completed date i.e.(07/05). The query will show Jan-05, Feb-05
and July-05. Is it possible to have all 12 months display in the query and
have the values show as 0?

Thanks
 
Raj said:
I create a crosstab that is used for monthly totals and is based off
the completed date. The query shows only the columns header for
months that are populated. There are time that we will have some
future orders and have to populate the completed date i.e.(07/05).
The query will show Jan-05, Feb-05 and July-05. Is it possible to
have all 12 months display in the query and have the values show as 0?

Thanks
Click to expand...

Set the ColumnHeadings property of the query. This allows you to return all
possible columns (even those without data) and also control the order the
columns are displayed.
 
Rick,
Thank you..

Rick Brandt said:
Set the ColumnHeadings property of the query. This allows you to return all
possible columns (even those without data) and also control the order the
columns are displayed.
Click to expand...
 
Back
Top