Want to show Mon date if there is activity in the week not on Mon

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

Guest

I am trying to run a report in Access by week. The report is grouping by
week; however, if there is no activity on the Monday of that week, the date
in the header is showing whatever date the first activity for the week is
appearing. I need that header date to always be the Monday of the week
regardless if there is activity on that day or not. Is there a way to make
this happen?
 
You will need to use a formula to calculate Monday date

= DateAdd("d", 2- WeekDay([YourDateHere],2), [YourDateHere])
 
Back
Top