1 2 3 4 5 6 7
| PARAMETERS
[Forms]![ParametresDates]![Debut] DateTime,
[Forms]![ParametresDates]![Fin] DateTime;
SELECT T_JOURNEE.ID_COMPETITION, T_JOURNEE.LIB_COMPETITION, T_JOURNEE.ORDRE, T_JOURNEE.ID_EVENEMENT1, T_JOURNEE.VILLE_TERR, T_JOURNEE.HORAIRE, T_JOURNEE.POULE, T_JOURNEE.NUMERO_RENCONTRE, T_JOURNEE.DATE_MATCH, T_JOURNEE.CL, T_JOURNEE.CV, T_JOURNEE.NOM2, T_JOURNEE.ARBITRES, T_JOURNEE.JT1, T_JOURNEE.JT2, T_JOURNEE.OFFICIEL
FROM T_JOURNEE
WHERE (((T_JOURNEE.ID_COMPETITION)<>(358493) And (T_JOURNEE.ID_COMPETITION)<>(360608) And (T_JOURNEE.ID_COMPETITION)<>(357133) And (T_JOURNEE.ID_COMPETITION)<>(362547) And (T_JOURNEE.ID_COMPETITION)<>(372615) And (T_JOURNEE.ID_COMPETITION)<>(373243)) AND ((T_JOURNEE.DATE_MATCH) Between [Forms]![ParametresDates]![Debut] And [Forms]![ParametresDates]![Fin])); |
Partager