Group dates into weeks for 1 year

  • Thread starter Thread starter ken@home
  • Start date Start date
K

ken@home

How can i do the above for a number of records that i have
in a table. Dates are not consecutive, (but i will sort
them)i need to know the start and end date of each week
and the number of records in that week.
I will be calculating the mean later.
 
How can i do the above for a number of records that i have
in a table. Dates are not consecutive, (but i will sort
them)i need to know the start and end date of each week
and the number of records in that week.
I will be calculating the mean later.
Click to expand...

Take a look at:

DatePart("ww", [datefield])

This function returns a week number, from 1 to 54, and has some
options for determining the meaning of the "first week of the year"
(is it the week containing January 1? the week containing the first
Monday? or what?)

You can use this as a calculated field in a Totals query to group by
week, and count records within that week.
 
Back
Top