Best to do it in the query as a computed column in the way I described in my
last post. Then you can group on the column and include a text box in the
group header with a control source such as:

="Week starting " & [WeekStarting]

You can of course format the [WeekStarting] value in any way you like, e.g.

="Week starting " & Format([WeekStarting], "dddd mmmm dd yyyy")

would give you a heading in the format:

Monday May 31 2010

Ken Sheridan
Stafford, England

Alaska1 wrote:
Thank you for taking the time to answer my question. The Format([The Date],
"yyyy-mm") would work to sum and group the date but 2010-17 is not going to
be familiar to those looking at the report.

I will try your public function. Just not sure, I am doing the function in
the report or the query?

The Format function is, so you could call it directly with:

[quoted text clipped - 53 lines]
5/24/2010 - 5/28/2010 5 time sheets returned
.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/201005/1