Weekly Query Help

[123anthony]

Hi I need to group some dates from a table so that in my query, it groups weeks. How would I do this? Thanks.

 

[SkipVought]

Hi,

A method I use...
[tt]
WkOf: INT(({TheDateField]-2)/7)*7)
[/tt]
returns previous the Saturday for any given date. Add 2 and it returns a Monday.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[PHV]

You may group by Format([date field], "ww")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[123anthony]

Well I tried both, the first I can't get to format right and the second just displays the week number relevant to the year. Im still a bit stuck, can anyone help?

 

[PHV]

So, which result do you want with which input data, and what have you tried so far ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[123anthony]

Well what I have in my table are loads of different dates. In my query, I want these to be grouped in weeks with it showing the week commencing. Thanks.

 

[PHV]

So, you want to group by this ?
StartOfWeek: [Date field]-Weekday([Date field],2)+1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[123anthony]

Thats exactly it! Thanks so much for your help.