Join and Summarize by Week
OK, so far the easiest way that I've found to join two dissimilar sets of data by week (i.e. group all stuff in the same week together) is to use a combination of two fields built using the Access datepart function.
One: datepart('ww', [thedates1])
Two: datepart('yyyy', [thedates1])
This gives you a week ID and the four digit year. Then join accross data sets and your are flying.
>> Leonard Chan's Homepage
>> Scribble Web
>> Join and Summarize by Week