Setting weekly date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top