Need both FIXED ROW and COLUMN headings in crosstab report 1

[MeisoT]

I have a report based on a crosstab query. I'm using fixed column headings showing each month of the year.

I also need to have fixed row headings so that if there is no data for a field in the row headings, the field name should still display and then just show zero values for each month of the year. In the example below, Item2 would not normally show because no records are returned. I need Item2 to display and then just show zero values.

Jan Feb March April etc.
Item1 5 24 30 0
Item2 0 0 0 0
Item3 2 7 15 8
Item4 0 14 89 2
Item5 4 0 0 0

How can I accomplish this - both fixed row and column headings? Any ideas you can offer would be greatly appreciated.

 

[dhookom]

Are you having trouble with columns or just rows. If your only issue is the rows, you should use a join to your table of all unique items that includes all records from the items table. You can use a value expression that displays 0 rather than nulls. If you need more help, share your table structure and SQL view.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[MeisoT]

Thanks. Your suggestion worked like a charm!!!!