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

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?
 
J

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

Similar Threads

Display a weekending date even if there is no data 5
Count # ckbxs chkd (mon-fri) in rpt rec to count wkly sessions 1
Date Header for Week 6
Group Week Sunday to Saturday 5
Specific Date Headers 3
Date Format In A Report 2
Crosstab Report Problem when data missing 1
week commencing date 1

Top