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?

 

[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")