Re: Force Row Headings in Crosstab?

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

Jan
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

Feb
Days TotalIssues IssueA IssueB IssueC
1 4 2 2 0
2 1 1 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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"Jeff Schneider" <JeffSchneider@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:84F5BDF4-14F2-41DC-B5F9-93BA936BAAC8@xxxxxxxxxxxxxxxx
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





.