1 2 3 4 5 6 7 8 9 10
| SELECT tblClients.IDAchat, tblClients.DateCommande, tblClients.CommandeMois,
tblClients.PrixUnitaire, tblClients.Client, tblClients.Nb_Mois,
DateAdd("m",[Nb_Mois],[DateCommande]) AS Dernier_Mois, [Client] & " " &
[CommandeMois] & " colis Pendant " & [Nb_Mois] & " mois = " & [MontantCommande]
& " " AS CommandClient, TblCount.Id, DateAdd("m",[Id],[DateCommande]) AS [A Livrer le],
tblClients.CommandeMois, [CommandeMois]*[PrixUnitaire] AS MontantCommande
FROM tblClients, TblCount
WHERE (((tblClients.DateCommande)>[Formulaires]![frmTestDate]![Datedebut])
AND ((DateAdd("m",[Nb_Mois],[DateCommande]))
<[Formulaires]![frmTestDate]![DateFin]) AND ((TblCount.Id)<=[Nb_Mois])); |
Partager