I think you're looking at 2, maybe 3 queries.
1. would be a Totals query, grouped by action, calculating the Max of date field
2. would be a Totals query, grouped by action, calculating the Min of date field, but based on your flag column because you wrote
I indicate if an action on the report was on the previous week's report
If all you did to create that indicator was to format the text, then I don't know (sorry, I didn't download your sample - yet).
Then a query that connects the two. I could be wrong (as is often the case), but I don't see how you can have both Min and Max aggregate functions on the same grouping in one query. If anyone can do this with a sub query, I'm sure they'll chime in. I don't have a lot of success attempting those.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.