Sorting Help

[kentwoodjean]

I have a query that I have built a report from. The data is grouped and the "Call Date" format is Mo/Day/Year. I have indicated in my query how to format my date: Month: Format([Call Date],"mmmm yyyy&quot. Because I want the report to sort my dates beginning with Jan 2002 and end with July 2003 for each grouping, I also have a sort field on my query:MySort: Month([Call Date]). How do I also indicate in this sort field that I also want it to consider the year? I have tried several combinations and nothing seems to work. By just using Month, it only considers 1-12 for the months, and therefore cannot overlap years.

 

[DrSimon]

I'm afraid I'm not clear what you want. If you want to group conventionally by month (Jan 2002, Feb 2003,...Dec 2002, Jan 2003... July 2003) you just group on a normal date field and set 'Group on' to Month. Is that any use?
Simon Rouse