1 2 3 4 5 6 7 8
|
UPDATE StatistiquesAO SET
[Sum FAT] = DSum("FAT","StatistiquesAO","Periode<=" & fUsDate([Periode]) & " and Periode > " & fUsDate(DateAdd("m",-12,[Periode]))),
[Sum LTI] = DSum("LTI","StatistiquesAO","Periode<=" & fUsDate([Periode]) & " and Periode > " & fUsDate(DateAdd("m",-12,[Periode]))),
[Sum RWC] = DSum("RWC","StatistiquesAO","Periode<=" & fUsDate([Periode]) & " and Periode > " & fUsDate(DateAdd("m",-12,[Periode]))),
[Sum MTC] = DSum("MTC","StatistiquesAO","Periode<=" & fUsDate([Periode]) & " and Periode > " & fUsDate(DateAdd("m",-12,[Periode]))),
[Sum FAC] = DSum("FAC","StatistiquesAO","Periode<=" & fUsDate([Periode]) & " and Periode > " & fUsDate(DateAdd("m",-12,[Periode]))),
[Sum Man Hours] = DSum("WorkHours","StatistiquesAO","Periode<=" & fUsDate([Periode]) & " and Periode > " & fUsDate(DateAdd("m",-12,[Periode]))); |
Partager