How to group by weekly in a Microsoft Access Query

[JFord39]

Trying to run a query and group my data weekly. I have a set of data that consists of 06/02/07-08/31/2007 data. How would I go about group this data weekly?

 

[SkipVought]

Hi,

All kinds of ways. I use

Select INT(([DateField]-1)/7)*7+1 as WeekOf

results in SUNDAY dates.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}