Setting weekly date range

[Guest]

I would like to have my report sort weekly, but I need it to show the actual
date, ie, Week of 10/23/05, not just the week number since the beginning of
the year.

How can I do this?

Thank you

 

[Guest]

In the record source of the report, you display both fields, but in the
sorting and grouping select only the new field WeekNum, and sort the report
by this field

Select DateField , DatePart("ww",[DateField]) as WeekNum From TableName