Thank you both, I have some manipulating to do, both still sum the wrong totals.
I got it... thank you. They both work correctly...
(FYI there is an error in the spreadsheet example (sum of 9/10)
(I want to group by the ending date)
With June's: I used ([dtm_Date]-Weekday([dtm_Date],4)+7)
With orange's:
Code:
SELECT [dtm_Date]-Weekday([dtm_Date],4)+7 AS WeekStartDate_WeekNO
, Sum([lng_Quantity]) AS SumOfQuantity, Sum([dbl_TotalCost]) As SumOfTotalCost
FROM tbl_Sample
WHERE (((dtm_Date) Between DateAdd("d",-83,EndingTuesday(#9/13/2019#)) And EndingTuesday(#9/13/2019#)))
GROUP BY [dtm_Date]-Weekday([dtm_Date],4)+7
ORDER BY [dtm_Date]-Weekday([dtm_Date],4)+7;