1 2 3 4 5 6 7 8 9
|
PARAMETERS [IDEmployé désiré] Long, [Date de début] DateTime;
TRANSFORM Max(Format([DateHeure],"dd/mm/yyyy hh:nn")) AS HJ
SELECT Pointage.Type
FROM Pointage
WHERE (((Pointage.IDEmployé)=[IDEmployé désiré]) AND ((Pointage.DateHeure)>=[Date de début] And (Pointage.DateHeure)<DateAdd("d",7,[Date de début])))
GROUP BY Pointage.Type, Format$([DateHeure],"Short Time"), Pointage.IDEmployé, Pointage.IDPointage
ORDER BY Format$([DateHeure],"Short Time")
PIVOT Format([DateHeure],"dddd") In ("lundi","mardi","mercredi","jeudi","vendredi","samedi","dimanche"); |
Partager