Query with Weekly Sum or Total instead Month,Quarter,year

[Sandip]

Hi
I want to make query which should give sum or total or Avg on week basis instead of Unique Date/Time,Day,Month,Quarter or Year
If anyone can help ( I need Sum from Monday to Sunday)
Sandip
I need detail for full year on weekly basis not only for any selected week

 

[Sandip]

Thanks
Partly problem solved as I came to know extraction of weeks but still i have to work and think how to total pertcular field on week basis and in report display start and end date for the same
My actual need is like this
I have Patients data who takes treatments every week, some patients take 1 treatment per week some 2 some 3 etc. I need count of patients taking treatments 1,2,3 etc per week on monthly basis.
If you can help further
Thanks again
Sandip

 

[Sandip]

Thanks Pat
My problem is now I need Start date and End date of that week numbers to print in that report such that eg. week no 43 of 2004 Start date 10/17/04 and End date as 10/24/04 so I need to convert week no. to start date and end date(Reverse of Datepart("ww",[date])) I don't know how to do this in query??
Sandip

 

[Sandip]

Still waiting to get some help on above
Thanks
Sandip

 

[Sandip]

Hi Pat
Thanks again
But I did found some solution
In my main query I made Expression field as
Start Date: Format([date]-Weekday([date],2)+1,"mm-dd-yyyy")
End Date: Format([date]-Weekday([date],2)+7,"mm-dd-yyyy")
which gives me Start date(Monday) and End date (Sunday)
This I can use any time to get Start and End date of perticular Week
Sandip

 

[Sandip]

Thanks Pat
I will keep this in mind
but I am not using Public Functions or Modules because of lack of knowladge
but will be keen on learning the same so if you can suggest Website or Samples of Datbase to look
Sandip

 

[Sandip]

Thanks Pat
But couple of times I tried to use module or Function it did not work may be I don't know exect way to use it in Forms or Report
I will keep trying
Thanks again