1 2 3 4
| SELECT DISTINCTROW [tClients].nomClient, Format(Nz(Month([DateAnniversaire]),0),"00") & Format(Nz(Day([DateAnniversaire]),0),"00") AS t
FROM [tClients]
WHERE (((Format(Nz(Month([DateAnniversaire]),0),"00") & Format(Nz(Day([DateAnniversaire]),0),"00"))>=Format(Month([forms]![monForm]![DateDebut]),"00") & Format(Day([forms]![monForm]![DateDebut]),"00") And (Format(Nz(Month([DateAnniversaire]),0),"00") & Format(Nz(Day([DateAnniversaire]),0),"00"))<=Format(Month([forms]![monForm]![DateFin]),"00") & Format(Day([forms]![monForm]![DateFin]),"00")))
WITH OWNERACCESS OPTION; |
Partager