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
Author:
leonard
Date Updated:
2006-09-27 14:27:06
Date Created:
2006-09-27 14:27:06

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> Join and Summarize by Week

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.