1 2 3
| SELECT Client.[DATE CONTRAT], Client.NUMCONTRAT, Client.NUMCLIENT, Client.NOMPRENOMS, Client.ADRESSE, [CODE POSTAL].[CODE INSEE], Client.ORDRE, Client.STATUS, [CODE POSTAL].VILLE, Client.[TYPE DE RACCORDEMENT], Client.[STATUS DE RACCORDEMENT], Client.[TYPE DE DEGROUPAGE], Client.TECHNOLOGIE, Client.PROFIL
FROM Client INNER JOIN [CODE POSTAL] ON Client.[CODE POSTAL] = [CODE POSTAL].[Code Postal]
WHERE (((Client.[DATE CONTRAT])>=#" & Format(me.[DateDeb],"mm/dd/yyyy") & "# And (Client.[DATE CONTRAT])<=#" & format(me.[Datefin],"mm/dd/yyyy") & "#")); |
Partager