I have a table TTimeRecords with records including DateofJob and HoursofWork.
DateofJob | HoursOfWork
1/1/19 | 6.0
1/2/19 | 8.0
1/2/19 | 6.0
1/3/19 | 7.0
1/3/19 | 8.0
I then wanted to create a query in which hours were summarized for 2019 on a weekly basis, with...