1 2 3 4
| SELECT A.[date du releve], A.[Releve compteur], B.[date du releve] As [Date dernier relevé] , DateDiff("d",Nz(B.[Date du releve],A.[Date du releve]),A.[Date du Releve]) As [Nb jours], (A.[Releve compteur]-Nz(B.[Releve Compteur],A.[Releve Compteur]))/DateDiff("d",Nz(B.[Date du releve],A.[Date du Releve]-1),A.[Date du Releve]) As [Moyenne quotidienne]
FROM Releves As A LEFT JOIN Releves As B ON B.[Date du releve]<A.[Date du Releve]
WHERE B.[Date du Releve] IS NULL
Or B.[Date du Releve]=(SELECT MAX([Date du Releve]) FROM Releves WHERE [Date du Releve]<A.[Date du releve]); |
Partager