Sort Grouped Data by Week

[vikin9]

I need to sort some grouped data by week for an MS Graph in a Report. The data spans over a year and must sort chronologically to graph correctly. This works great if I group by month using the format "yyyy-mm," which always gives a two digit month (i.e. 2001-03, 2001-04, etc.). If I switch to "yyyy-ww," the week of the year switches to a single digit and the sort order changes to alphanumeric (i.e. 2001-1, 2001-10, 2001-11...2001-2, 2001-20, 2001-21, etc.). I can't find a way to force the ww to always be two digits. I'd be grateful for any suggestions. Thanks.

 

[Guest_imported]

Create a query that shows weeks correctly, like "2001-01" rather than "2001-1", and use it as the data source.