Crosstab by Month

[Bill]

Hi,

I am trying to figure it out. I create a crosstab to make a list of items by Month. I notice that I have Feb, Mar, July, Sept with a list of items. When I create a report (design) and have Feb, Mar, Jul and Sept but nothing for Jan, April, etc. I like to see a list by Month in Landscape Report.


Items Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Total

Paper 0 2 5 0 7 0 8 0 1 0 0 0 23
zzz
qqq
eeee
rrrr


I try to make some reports but I run into a problem.
Your feedback would be much appreciated.

Angelo

 

[Duane Hookom]

You can set the Column Headings property to "Jan","Feb","Mar",..."Dec"

--
Duane Hookom
MS Access MVP


Hi,

I am trying to figure it out. I create a crosstab to make a list of items
by Month. I notice that I have Feb, Mar, July, Sept with a list of items.
When I create a report (design) and have Feb, Mar, Jul and Sept but nothing
for Jan, April, etc. I like to see a list by Month in Landscape Report.


Items Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Total

Paper 0 2 5 0 7 0 8 0 1 0 0
0 23
zzz
qqq
eeee
rrrr


I try to make some reports but I run into a problem.
Your feedback would be much appreciated.

Angelo