1 2 3 4
| SELECT TableClient.TITRE, TableClient.NOMCLI, TableClient.PRENOMCLI, TableClient.DATARR, TableClient.DATDEP, TableClient.DATFIN, TableClient.HEUARR, TableClient.HEUDEP, TableClient.HEUFIN, TableClient.CODCDC, TableClient.MOTVIS, TableClient.ORDCLI, MotifVisite.MotifVisite
FROM MotifVisite INNER JOIN TableClient ON MotifVisite.N° = TableClient.MOTVIS
WHERE (((TableClient.DATARR) Between [Forms]![frmEditions]![Date_01_bis] And [Forms]![frmEditions]![Date_02_bis]) AND ((TableClient.CODCDC) Between [Forms]![frmEditions]![Code_bis] And [Forms]![frmEditions]![Code_bis]))
ORDER BY TableClient.ORDCLI; |
Partager