Grouping query date by work week "Regan via AccessMonster.com" <u24090[ at ]uwe> 20.07.2006 01:19:35 I SQL below is what i kinda want just slightly changed. How do i get [date by week] column to group the date by work week. Our work week is Wed - Tues. Also how can i get it to display the week ending date i.e Week ending Employee Sum of Units 18/07/06 Bob 150 25/07/06 Bob 300 SELECT DISTINCTROW Format$(TimeSheet.Date,'ww yyyy') AS [Date By Week], TimeSheet.Employee, Sum(TimeSheet.Units) AS [Sum Of Units], Count(*) AS [Count Of TimeSheet] FROM TimeSheet GROUP BY Format$(TimeSheet.Date,'ww yyyy'), TimeSheet.Employee; Thanks if you can help -- Message posted via http://www.accessmonster.com

Re: Grouping query date by work week "Regan via AccessMonster.com" <u24090[ at ]uwe> 20.07.2006 05:52:26 Well i got it so its adding the units form wed - tues, But in the query table it comes up as num of wee ie Week Employee Sum of units 22 Jerry 787 22 Jodie 878 23 Jerry 898 23 Jodie 111 How can i turn the week number into the Weekending DAte i.e 23 = 06/06/06 24 = 13/06/06 25= 20/06/06 Here is what im using to get results so far SELECT DISTINCTROW Format$(TimeSheet.Date,'ww',4) AS [Date By Month], TimeSheet.Employee, Sum(TimeSheet.Units) AS [Sum Of Units], Count(*) AS [Count Of TimeSheet], Last(TimeSheet.Date) AS LastOfDate FROM TimeSheet GROUP BY Format$(TimeSheet.Date,'ww',4), TimeSheet.Employee; -- Message posted via http://www.accessmonster.com