Select med Group By og Dato

Nå men jeg fandt selv løsningen :-))


StrSQL="SELECT CAST(DATEPART(yyyy, Dato) as varchar(4)) + '-' + CAST(DATEPART(ww, Dato) as varchar(2)) AS Uge, SUM(FejlStr) AS Antal " &_
      "FROM tbl_NonC " &_
      "GROUP BY CAST(DATEPART(yyyy, Dato) as varchar(4)) + '-' + CAST(DATEPART(ww, Dato) as varchar(2)) "