Attn: Duane Crosstab by Month

[Bill]

Create like =count([....] for each month ??

Thanks for reply back to me.




***************************************************

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

 

[Duane Hookom]

View the crosstab query properties dialog and you will find a Column
Headings property. Fill in this property with values as suggested.

--
Duane Hookom
MS Access MVP


Create like =count([....] for each month ??

Thanks for reply back to me.




***************************************************

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