I think it needs to be done in VB, so this is the place, eh?

Here's the gist: I have data sorted in weekly buckets (demand per week) with static field names. (Week1, Week2, . . . Week39)

Week1 is always the current week.

I need to consolidate this into monthly buckets. . . anyone know how to do this?

(Note, this report could be ran any day of the month, and most likely will be run on a weekly basis. Therefore CurrentMonth could be anywhere from Week1-Week4 data, or only Week1)