group by weekly date

[JRS]

I have data by log date and I want my query to group calls by week Mon thru
Sun. I also want to do by month. Is there a way to set that up? thanks

Log Date
02/03/2008
02/05/2008
02/05/2008
02/05/2008
02/05/2008
02/06/2008
02/06/2008
02/07/2008
02/07/2008
02/07/2008
02/07/2008
02/08/2008
02/08/2008
02/08/2008
02/08/2008
02/09/2008
02/09/2008
02/10/2008
02/11/2008
02/11/2008
02/11/2008
02/11/2008
02/11/2008
02/11/2008

 

[dustinbrearton]

I have data by log date and I want my query to group calls by week Mon thru
Sun. I also want to do by month. Is there a way to set that up? thanks

Log Date
02/03/2008
02/05/2008
02/05/2008
02/05/2008
02/05/2008
02/06/2008
02/06/2008
02/07/2008
02/07/2008
02/07/2008
02/07/2008
02/08/2008
02/08/2008
02/08/2008
02/08/2008
02/09/2008
02/09/2008
02/10/2008
02/11/2008
02/11/2008
02/11/2008
02/11/2008
02/11/2008
02/11/2008

The DatePart function is probably going to work best to accomplish both.

DatePart(interval, date[,firstdayofweek[, firstweekofyear]])

Example from MS Access help is below

Dim TheDate As Date ' Declare variables.
Dim Msg
TheDate = InputBox("Enter a date:")
Msg = "Quarter: " & DatePart("q", TheDate)
MsgBox Msg