-3

I need your help with this table please.

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

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

Please see the picture to understand my question

user16217248
  • 3,119
  • 19
  • 19
  • 37
LULIIITA
  • 1
  • 1

1 Answers1

0

Exclude the date field from the grouping:

...
WHERE 
    statisticsABC.Date Between [STARTDATE] And [ENDDATE]
GROUP BY 
    DatePart("ww",statisticsABC.Date) 
Gustav
  • 53,498
  • 7
  • 29
  • 55