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



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?

John Spencer

You will need to use a formula to calculate Monday date

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question