Intelligent Date Display for Each Column

[pianoprodigy]

I have a report which shows a count calls from each city for 12 months backwards. I would like to create column headings which report the month and year of the cities beneath.

For instance, the first column would be for May 04 then April 04 and so on.

Can I format Today(m-1) displayed as mmmm yy?

I think you guys can figure out what I'm saying.

Thanks for the help.

Alan

 

[Rich]

Use a crosstab query and base the Report on that

 

[pianoprodigy]

Use a crosstab query and base the Report on that

How do I format the crosstab query to sort by Month AND Year. Using the wizard it gives me options by month and quarter and so on, but I can't seem to make it split them up by Month AND Year.

May 04 April 04 March 04 and so on...