Dynamic report based on Crosstab Query

[LostinAccess]

HELP! I am trying to create a dynamic report based on a crosstab query. The
rows represent BRANCHES, the Columns reflect MMM YYYY and the intersecting
values is an average score for that month for a respective branch. The query
works find, but I need to generate a report each month. I want the report to
basically look like an Excel spreadsheet, but of course with nice headers,
etc.

The query is based on a Make Table which is based on a crosstab query. The
field name BRANCH represents the row headings, the RPTMONTH represents the
column headings and AvgScore is the value and under Total is set as AVG.

The query works, but how do you create a DYNAMIC report since new data is
being entered daily??? Should not be so difficutl!

Need to see
ex Jan 08 Feb 08 Mar 08
Cum Ave
Branch 1 82% 83.5% 85%
83.5%
Branch 2 96% 98% 97%
97%
Branch 3
etc.

 

[KARL DEWEY]

Based on how you want the data displayed - rolling 12 months with current
month to the right. Use a calculated textbox instead of label in the report.

Or as your example always have Jan of current year as the left most. Again
a calculated textbox - "Jan " & Year(Date()) through "Dec " & Year(Date())
for labels.

 

[Duane Hookom]

Consider the dynamic monthly crosstab solution found at
http://www.tek-tips.com/faqs.cfm?fid=5466.