Displaying week as date rather than week number

[Michael Bentfeld]

I currently have a report that groups records by week.
Currently, the group header for each week shows each week
as the number of the week in the year. For example, the
week of 9/22/03-9/28/03 is given as week 39. Is there a
way I can format the group header to show the week covered
using the dates instead of the week number, so that the
report would be easier to understand?

 

[Van T. Dinh]

Please post the SQL String (of the Query) which is being used as the
RecordSource for the Report.

 

[John Vinson]

Is there a
way I can format the group header to show the week covered
using the dates instead of the week number, so that the
report would be easier to understand?

You might try setting the Control Source of a textbox to

"Week Of " & Format(DateAdd("ww", [WeekNo], DateSerial(Year(Date()),
1, 1), "mm/dd/yyyy-") & Format(DateAdd("ww", [WeekNo] + 1,
DateSerial(Year(Date()), 1, 1) - 1, "mm/dd/yyyy")