Week

[Bob]

I want sort date by weeknumbers. So i have a query that show me the
weeknumber and the meldingen that are made in that week.

The code i use is :

select datevalue(datum) AS DATA, count(melding.id) AS AantalvanID
From Melding
Group by datevalue(datum);

 

[Jerry Whittle]

SELECT DatePart("w",DateValue(datum)) AS DATA,
Count(melding.id) AS AantalvanID
FROM Melding
GROUP BY DatePart("w",DateValue(datum))
ORDER BY 1 ;