Access SQL - group data by week for current month ( 4 or 5 weeks only per month )

LULIIITA 0
Viewed 32

i need you help with this table please

GROUP BY DatePart("ww",[date]), statisticsABC.Date HAVING (((statisticsABC.Date) Between [STARTDATE] And [ENDDATE]));

i used this one DatePart("ww",[date]) but it shows me data like this

please see the picture to understand my question

ms-access-2016 sql
1 Answers

Exclude the date field from the grouping:

...
WHERE 
    statisticsABC.Date Between [STARTDATE] And [ENDDATE]
GROUP BY 
    DatePart("ww",statisticsABC.Date)
uservDNe0
Related