group by week but want to display week start and end dates

[scottian]

im trying to compile a report which offers summary info grouped by week. however i also want to display the start and end dates of the week. i.e
WEEK Dates FROM and TO
week1 1st Jan 7th Jan

Ive tried this in the query:-
MyDateFrom: DMax([MyDate],"qryMyReport",Format([MyDate],'ww\,yyyy')=Format(Now(),'ww\,yyyy'))
MyDateFrom: DMin([MyDate],"qryMyReport",Format([MyDate],'ww\,yyyy')=Format(Now(),'ww\,yyyy'))


but it doesnt do anything. Does anyone know how to do it. Ive checked previous threads but cant seem to find anything even close to what i need.

"My God! It's full of stars...

 

[Remou]

Have you seen (?):

How to determine the First/Last day of a week
faq701-3103