SELECT dbo_legheader.lgh_driver1, DateValue([lgh_startdate]) AS Jour1, DateValue([lgh_enddate]) AS JourFin, IIf([Jour1]+1>[JourFin],0,DateValue([lgh_startdate]+1)) AS jour2, IIf([jour1]+2>[jourfin],0,DateValue([lgh_startdate]+2)) AS jour3, IIf([jour1]+3>[jourfin],0,DateValue([lgh_startdate]+3)) AS jour4, IIf([jour1]+4>[jourFin],0,DateValue([lgh_startdate]+4)) AS jour5, IIf([jour1]+5>[jourfin],0,DateValue([lgh_startdate]+5)) AS jour6, IIf([jour1]+6>[jourfin],0,DateValue([lgh_startdate]+6)) AS jour7
FROM dbo_legheader
WHERE (((dbo_legheader.lgh_driver1)="FLEURM" Or (dbo_legheader.lgh_driver1)="fortij" Or (dbo_legheader.lgh_driver1)="levayf" Or (dbo_legheader.lgh_driver1)="rouleb" Or (dbo_legheader.lgh_driver1)="royric" Or (dbo_legheader.lgh_driver1)="vielbe") AND ((DateValue([lgh_startdate])) Between #1/21/2007# And #2/17/2007#))
ORDER BY dbo_legheader.lgh_driver1, DateValue([lgh_startdate]);
Partager