I have a datasheet that organizes items by date ("mm/dd/yy") and would like to build a query that can count the number of entries by week. How do I build a query that can group/assign into weeks of the year?
A starting point (SQL code):
SELECT Format([date field],'yyyy-ww') As Week, Count(*) As NumberOfEntries
FROM yourTable
GROUP BY Format([date field],'yyyy-ww')
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.