1 2 3 4 5 6 7 8 9 10 11 12 13 14
| SELECT Sum(IIF(Month([facture_date])=1,1,0)) As Janvier,
Sum(IIF(Month([facture_date])=2,1,0)) As Février,
Sum(IIF(Month([facture_date])=3,1,0)) As Mars,
Sum(IIF(Month([facture_date])=4,1,0)) As Avril,
Sum(IIF(Month([facture_date])=5,1,0)) As Mai,
Sum(IIF(Month([facture_date])=6,1,0)) As Juin,
Sum(IIF(Month([facture_date])=7,1,0)) As Juillet,
Sum(IIF(Month([facture_date])=8,1,0)) As Août,
Sum(IIF(Month([facture_date])=9,1,0)) As Septembre,
Sum(IIF(Month([facture_date])=10,1,0)) As Octobre,
Sum(IIF(Month([facture_date])=11,1,0)) As Novembre,
Sum(IIF(Month([facture_date])=12,1,0)) As Decemenbre
FROM facture
WHERE (((Year([facture_date]))=2007)); |
Partager