Date(MonthStart(weekEnding),'YYYY-MM') as yearMonth,
(ooxml, embedded labels, table is qryDriverScorecardByWeek);
I did not add just the date function, I added the MonthStart. The issue is that date is just a formatting function and doesn't really remove the day just because it formatted it YYYY-MM. It would still repeat for each day (and time if weekEnding is a timestamp). To get rid of all extra things, I just made all the dates 1st of the month using MonthStart and then assign them your required date format using Date() function.