Group dates into weeks for 1 year

[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.

 

[John Vinson]

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.

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.