Solved Summary report, subtotals grouped by week

[Sander1234]

Hello all

I've been working on a small database for my mom where she enters orders of customers, a date and a price. Now I'm struggling with creating a report that shows the subtotals of every customer grouped by week (columns) whithin one month. I've already managed to create the report where I isolate the orders whithin one month and i have created 5 queries in order to group and sum the totals between a date range (1-7; 8-14; ...) --> I need columns with a subtotal for every week. Now the thing is: this system does not take into account that weeks start on monday and end on sunday... for example: Feb 2020 only needs the subtotals from 1 to 6 cause 7 Feb is a new week.
How should I alternatively group these orders?

Sorry for my bad English and explanation. I hope some of you will understand my question

Also I added a picture to clarify the report I need.

 

[SHANEMAC51]

Sorry for my bad English and explanation. I hope some of you will understand my question

Also I added a picture to clarify the report I need.

an example of a database would be more useful for understanding your task

the week from December 27 to January 2 is more interesting, what is the number of the week and what year it belongs to