Force Row Headings in Crosstab?

J

Jeff Schneider

I know how to force Column Headings in a Crosstab Query. Is there a way to
force Row Headings as well?

Current query gives this:
Days TotalIssues IssueA IssueB IssueC
1 3 2 1 0
3 2 1 1 0
4 1 0 1 0
7 1 1 0 0

I want it to look like:
Days TotalIssues IssueA IssueB IssueC
1 3 2 1 0
2 0 0 0 0
3 2 1 1 0
4 1 0 1 0
5 0 0 0 0
6 0 0 0 0
7 1 1 0 0
 
D

Duane Hookom

Create a table with all days. Add this table to a query with the results of
your crosstab. Set the join line to include all the records from the table
of days.
 
J

Jeff Schneider

As always: a simple solution to a seemingly difficult question (at least in
my mind!).

Thank you again!
 
C

Chris

Duane Hookom said:
Create a table with all days. Add this table to a query with the results of
your crosstab. Set the join line to include all the records from the table
of days.
Click to expand...
 
C

Chris

How do you do this is you want to see the same weekly data by month as well?

Jan
Days TotalIssues IssueA IssueB IssueC
Feb
Days TotalIssues IssueA IssueB IssueC
 
Top