Solved Summary report, subtotals grouped by week (1 Viewer)

Sander1234

New member
Local time
Today, 01:19
Joined
Feb 23, 2022
Messages
1
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.
 

Attachments

  • Knipsel.PNG
    Knipsel.PNG
    6.4 KB · Views: 176

SHANEMAC51

Active member
Local time
Today, 02:19
Joined
Jan 28, 2022
Messages
288
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
 

Users who are viewing this thread

Top Bottom