1 2 3 4 5
| SELECT Facture.NumFacture, Facture.CdeVoyage, Voyage.IntituléVoyage, TypeVoyage.TypeVoyage, Client.NomClient, Nz([PUPdt1],0)*Nz([QttéPdt1],0)+Nz([PUPdt2],0)*Nz([QttéPdt2],0)+Nz([PUPdt3],0)*Nz([QttéPdt3],0)+Nz([PUPdt4],0)*Nz([QttéPdt4],0)+Nz([PUPdt5],0)*Nz([QttéPdt5],0)+Nz([PUPdt6],0)*Nz([QttéPdt6],0)+Nz([PUPdt7],0)*Nz([QttéPdt7],0)+Nz([PUPdt8],0)*Nz([QttéPdt8],0)+Nz([PUPdt9],0)*Nz([QttéPdt9],0)+Nz([PUPdt10],0)*Nz([QttéPdt10],0)+Nz([PUPdt11],0)*Nz([QttéPdt11],0)+Nz([PUPdt12],0)*Nz([QttéPdt12],0) AS Total
FROM (Voyage INNER JOIN TypeVoyage ON Voyage.CdeType = TypeVoyage.CdeType) INNER JOIN (Client INNER JOIN Facture ON Client.NumClient = Facture.NumClient) ON Voyage.CdeVoyage = Facture.CdeVoyage
GROUP BY Facture.NumFacture, Facture.CdeVoyage, Voyage.IntituléVoyage, TypeVoyage.TypeVoyage, Client.NomClient, Voyage.DateDébutVoyage, Voyage.CdeType
HAVING (((Voyage.DateDébutVoyage) Between #10/1/2006# And #10/31/2006#) AND ((Voyage.CdeType)=4))
ORDER BY Voyage.DateDébutVoyage; |
Partager