1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
|
PARAMETERS lamarque TEXT (255), debperiode DATETIME, finperiode DATETIME, lavaleur TEXT (255);
INSERT INTO tmarqueperiodevaleur
(marque,
période,
valeur)
SELECT [lamarque] AS M,
Dateserial(Year([debperiode]) + [annee.n] - 1, [mois.n], [jour.n]) AS d,
[lavaleur] AS v
FROM tnombre AS Annee,
tnombre AS Mois,
tnombre AS jour
GROUP BY [lamarque],
[lavaleur],
Dateserial(Year([debperiode]) + [annee.n] - 1, [mois.n], [jour].[n])
HAVING Dateserial(Year([debperiode]) + [annee.n] - 1, [mois.n], [jour.n])
BETWEEN
[debperiode] AND [finperiode]
AND Dateserial(Year([debperiode]) + [annee.n] - 1, [mois.n], [jour.n])
NOT IN (
SELECT T.période
FROM
tmarqueperiodevaleur AS T
WHERE
T.marque = [lamarque]
AND T.période BETWEEN [debperiode] AND [finperiode]
GROUP
BY T.période
HAVING SUM(Val([valeur] & "")) + Val([lavaleur]) > 20
OR ( SUM([valeur] = "v") + ( [lavaleur] = "v" ) <> 0
AND SUM([valeur] = "r") + ( [lavaleur] = "r" ) <> 0
)
OR Abs(SUM([valeur]="v")) + Abs([lavaleur]="v") > 1
OR Abs(SUM([valeur]="r")) + Abs([lavaleur]="r") > 1
OR ( SUM(Val([valeur] & "")) + Val([lavaleur]) <> 0
AND ( SUM([valeur] = "v") + ([lavaleur] = "v") <> 0
OR SUM([valeur] = "r") + ([lavaleur] = "r") <> 0)
)
) |
Partager