SELECT Encaisse.Compte, Encaisse.Date, Sum(Encaisse.CAD) AS SommeDeCAD
FROM Encaisse INNER JOIN Ententes ON Encaisse.Compte = Ententes.Compte
WHERE (((Encaisse.Date) Between [Ententes].[Date] And [Ententes].[Date]+[Ententes].[Duree]))
GROUP BY Encaisse.Compte, Encaisse.Date;