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.
Related Scribbles:
  • Microsoft Access Links

  • ID: 786
    Date Updated:
    2006-09-27 14:27:06
    Date Created:
    2006-09-27 14:27:06


     >> Leonard Chan's Homepage  >> Scribble Web  >> Join and Summarize by Week is hosted by Perceptus Solutions Inc.