Group data by custom weeks

Hello,


My user gives me startDate and finishDate as input.
I want to group my data by weeks whe
First week first day is startDate
Last week last day is finishDate

Can I do it by a query ?

Thank you for yuor help
Gil D.

On 12 Dec 2005 15:37:58 -0800, "Gil D." wrote:

Hello,


My user gives me startDate and finishDate as input.
I want to group my data by weeks whe
First week first day is startDate
Last week last day is finishDate

Can I do it by a query ?

Thank you for yuor help
Gil D.

You'll have to explain. What exactly do you want to group by? Week No.
1, Week No. 2? What if the range is not a multiple of 7? Could you
give an example of the data and how you would like it displayed?

John W. Vinson[MVP]

Hello,

I have a table named: Work
Each record contains workerID, workingDate, working hours etc.
I am trying to create a weekly chart/report.
My user give me as input: startData, endDate.

If Diff(startData, endDate) = 7 then
First week is: startDate,startDate+6
Second week is: startDate+7, startDate+13
....

If the range is not a multiple of 7 then last week will be shorter.
I need to display for my user weeks starting/ending date.

Example of the data and how you would like it displayed:

workerID, workingDate, working hours
1, 11/12/05, 10
2, 11/12/05, 10
1, 18/12/05, 5

User input:
startDate 11/12/05
endDate 22/12/05

Needed Output:
weekStartDate, weekEndDate, SumOfWorkingHours
11/12/05, 17/12/05, 20
18/12/05, 22/12/05, 5

Thank you for your help
Gil D.