Running Total problem

[Manos39]

I need to calcculate the running total of [ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ] in a new field my query :

SELECT QrSynolaT.ΕΠΩΝΥΜΟID, DatePart("yyyy",([ΑΝΑ ΜΗΝΑ])) AS ΕΤΟΣ, DatePart("m",([ΑΝΑ ΜΗΝΑ])) AS ΜΗΝΑΣ, Sum(QrSynolaT.[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]) AS ΩΡΕΣ
FROM QrSynolaT
GROUP BY QrSynolaT.ΕΠΩΝΥΜΟID, DatePart("yyyy",([ΑΝΑ ΜΗΝΑ])), DatePart("m",([ΑΝΑ ΜΗΝΑ]))
ORDER BY DatePart("yyyy",([ΑΝΑ ΜΗΝΑ])), DatePart("m",([ΑΝΑ ΜΗΝΑ]));

according to an example expression i found:
[ Field: RunTot: DSum("Freight","Orders","DatePart('m', _
[OrderDate])<=" & [AMonth] & " And DatePart('yyyy', _
[OrderDate])<=" & [AYear] & "")
Total: Expression
Show: Yes ]


I try to calcculate the running total with the expression Dsum but didnt managed.. can anyone help me?

 

[John Big Booty]

Perhaps this article will give you some pointers.