Crosstab query - generic collumn names - help please!

[Chloe]

I am using Access 2003 to create a project status reporting tool.

One of the reports in the tool is a traffic light diagram where each month a
project manager sets different Categories (Customer Satisfaction, Resources,
Quality etc.) either Red, Amber or Green depending on the projects' status.

I want to set up a report that will show the trend of these traffic lights -
show this month and the three previous months traffic lights.

My records are set up that each month there is a new record for each
projects traffic lights.

So far I have created a cross tab query with the Reporting Period as the
collumn heading, Project as the row heading and the RAG as the value.

This gives me the values I want but I want to limit this to only the current
month + the last three and also need to give the collumn headings generic
names (Rep_Period, Rep_Period-1, Rep_Period-2 etc) so that each month when a
new record is added the report will automatically update.

Any help anyone could offer would be greatly appreciated.

Thanks, Chloe

 

[John Spencer]

If you post the SQL of the crosstab, someone can suggest how to make the
needed change.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Duane Hookom]

It sounds like the solution found at
http://www.tek-tips.com/faqs.cfm?fid=5466 should work.