Weekly formula (Access 97)

[Guest]

I am creating a query that needs to calculate production statistics on a
weekly basis. I only see a way in Access 97 to summarize the data into
daily, monthly, quarter, yearly batches. Is there a way to change the
following formula (which is monthly) so that it will gather the data in
weekly increments?

Date By Month: Format$([Data].[Date],"mmmm yyyy")

I am in just the beginning stages of learning to program and I cannot get
this one figured out.
Heath

 

[Guest]

Hi Heathquad,
One way is to convert the date into week # in that year. Then you can
Summarize base on the year and week #.

WeekInYear: DateDiff("ww", "1/1/" & Year([DateField]), [DateField])

Hope this will help.