Does the query return the date range as a column, for example "1/7 to 1/13" or does it simply pass the date and have RS do the grouping? If RS is grouping by the dates at runtime, you might want to add a field to the query that groups them by week. (A date lookup table with a WeekNumberOfYear column is handy for things like this.) This way, you can have RS group by week#, which should be easier to code and less work for RS to process.