I have events with the dates they occured in my table/query. I want to present them in a pivot chart with one axis representing the dates for each monday of the current week back to monday 51 weeks ago.
How do I get my query to show the dates for 52 consecutive mondays starting this week and going back 51 weeks along with the dates and events I have captured in my table?
How do I get my query to show the dates for 52 consecutive mondays starting this week and going back 51 weeks along with the dates and events I have captured in my table?
