Access 2007 "group by" creating problem

[Art Vandaley]

Hi Everybody,

I have a query like following:

(Min) (Group By) (Sum)
YEAR WEEK TOTAL OF OVERTIME

2006 52 10
2007 1 15
2007 2 7
................................................
2007 51 12

When I put data for week 52 of 2007 my query adds the data to week 52 of
2006. And it adds the data of week1 of 2008 into week 1 of 2007. I try to
get below result from my query:

2006 52 10
2007 1 15
.........................................
2007 52 7
2008 1 8
..........................................

I think "group by" is preventing to get what I want.

Is there an idea? Regards.

 

[Baz]

You need to be grouping by YEAR as well as WEEK.

 

[PLASTICOS DAMARIS]

Hi Everybody,

I have a query like following:

(Min) (Group By) (Sum)
YEAR WEEK TOTAL OF OVERTIME

2006 52 10
2007 1 15
2007 2 7
...............................................
2007 51 12

When I put data for week 52 of 2007 my query adds the data to week 52 of
2006. And it adds the data of week1 of 2008 into week 1 of 2007. I try to
get below result from my query:

2006 52 10
2007 1 15
........................................
2007 52 7
2008 1 8
.........................................

I think "group by" is preventing to get what I want.

Is there an idea? Regards.

 

[Art Vandaley]

Hi,

Group by year together with group by week is not working. If I use group by
year I get below result:

(Group By) (Group By) (Sum)
YEAR WEEK TOTAL OF OVERTIME

2006 52 1
2006 52 2
2006 52 0
2006 52 4
2006 52 2
2006 52 0
2006 52 1
2007 1 5
2007 1 7
................................................

 

[Baz]

There is something else happening in your query which you haven't told us
about. Please post the SQL.