1 2
| SELECT DISTINCT Table5.numcli, DCount("numcli","Table5","[numcli] = '" & [numcli] & "'") AS nbcli, DSum("montantfact","Table5","[numcli] = '" & [numcli] & "'") AS totmontant, DSum("qtefact","Table5","[numcli] = '" & [numcli] & "'") AS totqte, DSum("coutrv","Table5","[numcli] = '" & [numcli] & "'") AS totcout, (DSum("montantfact","Table5","[numcli] = '" & [numcli] & "'")/DSum("qtefact","Table5","[numcli] = '" & [numcli] & "'"))-(DSum("coutrv","Table5","[numcli] = '" & [numcli] & "'")/DCount("numcli","Table5","[numcli] = '" & [numcli] & "'")) AS avgrentab
FROM Table5; |
Partager