1 2 3 4
| SELECT Residents.RefResident, Residents.NomFamille, Residents.Prenom, Residents.NomMarital, rq_Vignette_stat.numero_voie, rq_Vignette_stat.complement_voie, rq_Vignette_stat.libelle_voie, rq_Vignette_stat.DateFinValidite
FROM rq_Vignette_stat INNER JOIN Residents ON rq_Vignette_stat.RefResident = Residents.RefResident
WHERE (((rq_Vignette_stat.DateFinValidite)<Date() And (rq_Vignette_stat.DateFinValidite)>DateAdd("yyyy",-1,Date())))
ORDER BY Residents.NomFamille, Residents.Prenom, rq_Vignette_stat.numero_voie, rq_Vignette_stat.libelle_voie; |
Partager