I have a table actions which has fields actionid, actiondate, action.
I want to produce a list of actions which have been entered for the week we are in. For example, if the 2nd February were a Monday so the working week was 2 - 6th February, if I ran the report on any day of that week it would list out the actions during that week grouped by day. So, not the last 7 (or 5) days but based on the calendar week.
I have looked around but can't see how to do this. Does anyone have any suggestions please?