Did you review the Format() function as well as DatePart()?

--
Duane Hookom
MS Access MVP


"Roger" wrote in message
...
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