Group by week

[Grooz13]

Ok I have 2 questions.

First I need a query that will serve as a "log" of the number of order we had on each week of each years

lets say
Date: NumberofOrder:
week1-Year2000 11
week2-year2000 22


week1-year2001 07

my second query needs me to know how many order we had THIS WEEK, THIS YEAR

I tried many things but i'm lost... I used the datepart for the week but when I do this it gives me 1230 orders cause it adds all the order from this week from the previous years...

[RedWolf3x]

Please post the code you used to return the week values for all years, it seems all you may need to to append that to include a this year statement.

[Grooz13]

 
SELECT Count([Tbl_Soumission.Job_envoyee]) AS Services, DatePart("ww",[Tbl_Soumission.Job_envoyee]) AS wk
FROM Tbl_Soumission
WHERE (((Tbl_Soumission.No_Job) Like "*" & "S" & "*" Or (Tbl_Soumission.No_Job) Like "*" & "E" & "*"))
GROUP BY DatePart("ww",[Tbl_Soumission.Job_envoyee]);

this is my access sql

[RedWolf3x]

I may be incorrect here, but I think your issue could be solved of you add to your where statement

Add "And Year(Tbl_Soumission.Job_envoyee)-Year(Date())"

I'm fairly certain that will work.

-Red

[Grooz13]

I don't think this is what I'm looking for!

Your statement works flawlessly BUT!
what I want is not the number of orders by week only

but the number of lets say the orders i got on week 45 of years 2010 !

and If I had the code you just gave me, it only gives me the weekly order of this years !

I'm looking for something like
Date Orders
45-2011 26