Group by weekends

Hi,
Does anyone know how to group by weekends?
Sample data and expected results, please?
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> Hi,
> Does anyone know how to group by weekends?
|||Confused,
Do you want to summarise data whcih are falling on week ends ?
|||This is the data:
value year month day
34 2006 2 1
35 2006 2 2
50 2006 2 3
57 2006 2 4
63 2006 2 5
46 2006 2 6
44 2006 2 7
35 2006 2 8
48 2006 2 9
39 2006 2 10
52 2006 2 11
58 2006 2 12
41 2006 2 13
43 2006 2 14
44 2006 2 15
37 2006 2 16
38 2006 2 17
57 2006 2 18
52 2006 2 19
54 2006 2 20
45 2006 2 21
36 2006 2 22
41 2006 2 23
56 2006 2 24
49 2006 2 25
57 2006 2 26
45 2006 2 27
39 2006 2 28
I want the average of the value column but just per each weekend.
"dineshasanka@.gmail.com" wrote:

> Confused,
> Do you want to summarise data whcih are falling on week ends ?
>
|||Hi FJC,
Use a calendar table then you will be able to query the joined tables for
weekends only.
Cheers
David Birkedale
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> Hi,
> Does anyone know how to group by weekends?
|||is this homework?
hint. datediff(), mod()
|||What do you mean?
This answer says nothing.
"Doug" wrote:

> is this homework?
> hint. datediff(), mod()
>
|||Thanks David, it worked!
"David Birkedale" wrote:

> Hi FJC,
>
> Use a calendar table then you will be able to query the joined tables for
> weekends only.
> Cheers
> David Birkedale
>
> "FJC" <FJC@.discussions.microsoft.com> wrote in message
> news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
>
>