multiple months on one report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure this is possible but hopefully someone out there can tell me if
it is or not. I'm currently trying to produce a report that has multiple
columns on it one for each month in the year with a similar layout to below:-

April May June July ....
Item 1 Item 1 Item 1 Item 1
Avg days 11.2 9 32 12

Item 2 Item 2 Item 2 Item 2
Avg day 12 13 8 26

I've managed to produce the data in a select query but I can't get the
report layout as above. The report represents a number of products produced
by a company and the average number of day it takes to produce that item
within the month. All suggestions would be gratefully received. If I've not
explained myself properly please ask me to clarify.
 
I think I have done something similar to this. You can set up a group for the
item field. Then, create a formula in the group footer for each month. The
formula would depend on the amount field. I have included examples for
"April".
Amount field is Average Days:
Sum(IIF([Month_Field_Nm]="April",[Days_Field_Nm],0))
Amount field is Days (calculating average):
Sum(IIF([Month_Field_Nm]="April",[Days_Field_Nm],0))/Sum(IIF([Month_Field_Nm]
="April",1,0))

I hope this helps.
 
I would think a crosstab query (or queries) should work. It isn't clear why
Item 1 has a Row Header with "days" and Item 2 has "day".
 
Ok, I'll look at the crosstab query. The item two avg day was just a typo.
It should have read days.
 
Back
Top