1 2 3 4 5 6
| select [tblPlage].*,
Not insull(DFirst("Clef", "tblPlage", "#" & format([tblPlage].[DateDebutDebut], "yyyy\-mm\-dd hh:nn:ss") & "#" & " between [DateHeureDebut] and [DateHeureFin]")) as [EstDebutDansPeriodeExistant],
Not insull(DFirst("Clef", "tblPlage", "#" & format([tblPlage].[DateFinDebut], "yyyy\-mm\-dd hh:nn:ss") & "#" & " between [DateHeureDebut] and [DateHeureFin]")) as [EstFinDansPeriodeExistant],
Not insull(DFirst("Clef", "tblPlage", "#" & format([tblPlage].[DateFinDebut], "yyyy\-mm\-dd hh:nn:ss") & "#" & "<= [DateHeureDebut] and [DateHeureFin]<=" & "#" & format([tblPlage].[DateFinDebut], "yyyy\-mm\-dd hh:nn:ss") & "#")) as [EstEngloblePeriodeExistant],
[EstDebutDansPeriodeExistant] or [EstFinDansPeriodeExistant] or [EstEngloblePeriodeExistant] as [EstSuperpose]
from [tblPlage] |
Partager