I want to aggregate date data into weeks of the year. I have checked all date/time function and I can't seem to locate these types of functions. Seems strange to me since Access must have an internal calendar(s) to use the DateDiff function and other functions. What am I missing? Seems like this is a very common need. Any help would be greatly appreciated.

Thanks, Roger at