1 2 3 4 5 6
| SELECT [T-Article].Famille, Sum([T-LigneFacture].PoidsTotal) AS SommeDePoidsTotal, Year([DateDocument]) & IIf(DatePart("ww",[DateDocument],2) Between 1 And 9,0 & DatePart("ww",[DateDocument],2),DatePart("ww",[DateDocument],2)) AS N°Sem
FROM [T-Article] LEFT JOIN [T-LigneFacture] ON [T-Article].Code=[T-LigneFacture].CodeArticle
WHERE ((([T-LigneFacture].DateDocument) Between [DateDebut] And [DateFin]))
GROUP BY [T-Article].Famille, Year([DateDocument]) & IIf(DatePart("ww",[DateDocument],2) Between 1 And 9,0 & DatePart("ww",[DateDocument],2),DatePart("ww",[DateDocument],2))
HAVING ((([T-Article].Famille)<>"") AND ((Sum([T-LigneFacture].PoidsTotal))<>0) AND ((Year([DateDocument]) & IIf(DatePart("ww",[DateDocument],2) Between 1 And 9,0 & DatePart("ww",[DateDocument],2),DatePart("ww",[DateDocument],2)))>=201501))
ORDER BY Year([DateDocument]) & IIf(DatePart("ww",[DateDocument],2) Between 1 And 9,0 & DatePart("ww",[DateDocument],2),DatePart("ww",[DateDocument],2)); |
Partager