Group By Week Not Working?

[Chris2404]

Hi,

I have a query that I need to group by Week, however the week is defined as Monday - Sunday. For example the week commencing 10/06/2013 should include 10,11,12,13,14,15 & 16th however from the below query it only returns 10,11,12,13,14 & 15 and the 16th is used as the next week when it should be the 17th. The sample data and query used is below.

WC: ([Date])-(Weekday([Date])-2)

Query1
Date WC
10/06/2013 10/06/2013
11/06/2013 10/06/2013
12/06/2013 10/06/2013
13/06/2013 10/06/2013
14/06/2013 10/06/2013
15/06/2013 10/06/2013
16/06/2013 17/06/2013
17/06/2013 17/06/2013



Thanks for the help =)

 

[CazB]

Firstly: never call a date field "Date" - date is a reserved word in MSAccess!

that aside... try changing the formula to WC: ([date])-(Weekday([date],0)-2)

 

[Chris2404]

Perfect! Just had to change the 2 to a 1 but that you so much