Sort by Month in Cross Tab query

[Guest]

I've been able to sort by month by typing the months in the Description field
under the queries properties. For example April 07, May 07, etc. Since I
formated the date as "mmmm yy" this works but I would think there is a better
way since I don't always want to go into the properties and add new months &
years as the data gets older. Any suggestions?

 

[Guest]

JeffH
To clarify I'm entering April 07, May 07, etc in the Column Headings
properties.

 

[Allen Browne]

See:
Dynamic Monthly Crosstab Reports
at:
http://www.access.hookom.net/Reports.htm