1 2
| SELECT TEcheances.*, TEmprunts.RefCodeTaux, Day(DateSerial(Year([PeriodeDebut]),Month([PeriodeDebut])+1,0)) AS Mois1, Day(DateSerial(Year([PeriodeDebut]),Month([PeriodeDebut])+2,0)) AS Mois2, Day(DateSerial(Year([PeriodeDebut]),Month([PeriodeDebut])+3,0)) AS Mois3, TEcheances.DateTaux AS DateTaux1, [DateTaux]+[Mois1] AS DateTaux2, [DateTaux]+[Mois1]+[Mois2] AS DateTaux3, DLookUp("[Valeur Taux]","Vtaux","[Code Taux]='" & [RefCodeTaux] & "' and [Date Taux] = #" & Format([DateTaux1],"mm/dd/yy") & "#") AS ValTaux1, DLookUp("[Valeur Taux]","Vtaux","[Code Taux]='" & [RefCodeTaux] & "' and [Date Taux] = #" & Format([DateTaux2],"mm/dd/yy") & "#") AS ValTaux2, DLookUp("[Valeur Taux]","Vtaux","[Code Taux]='" & [RefCodeTaux] & "' and [Date Taux] = #" & Format([DateTaux3],"mm/dd/yy") & "#") AS ValTaux3
FROM TEmprunts INNER JOIN TEcheances ON TEmprunts.ID = TEcheances.RefNPret; |
Partager