I have a query chart that prints out some statistical data--everything is fine, but the months are grouped by 'months' and not chronologically...(EG April 2002, April 2003, April 2004, May 2002, May 2003, etc etc)
I have played with the following:
Date By Month: Format$([Advocacy_Single].[Date],'mmmm yyyy')
I tried to change this to
Date By Month: Format$([WRC_Advocacy_Single].[Date],'yyyy mmmm') But the order remained the same...
Did a few things actually...obviously missing something?