i have a query (Qrminas) to calculate a running sum of workhours of empoyees per month and i get #error in the field ΣΥΝΟΛΑ
SELECT Qrevdomada.[ΑΝΑ ΕΤΟΣ], Qrevdomada.[ΑΝΑ ΜΗΝΑ], Qrevdomada.ΥΠΑΛΛΗΛΟΣID, Qrevdomada.ΕΠΩΝΥΜΟ, Sum(Qrevdomada.[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]) AS [ΣΥΝΟΛΟ ΜΗΝΟΣ], DSum("[ΣΥΝΟΛΟ ΜΗΝΟΣ]","Qrevdomada","[ΑΝΑ ΜΗΝΑ] <= " & [ΑΝΑ ΜΗΝΑ] & " And [ΑΝΑ ΕΤΟΣ] <= " & [ΑΝΑ ΕΤΟΣ] & " And [ΥΠΑΛΛΗΛΟΣID] = '" & [ΥΠΑΛΛΗΛΟΣID] & "'") AS ΣΥΝΟΛΑ
FROM Qrevdomada
GROUP BY Qrevdomada.[ΑΝΑ ΕΤΟΣ], Qrevdomada.[ΑΝΑ ΜΗΝΑ], Qrevdomada.ΥΠΑΛΛΗΛΟΣID, Qrevdomada.ΕΠΩΝΥΜΟ;
[ΑΝΑ ΕΤΟΣ]= year date field
[ΑΝΑ ΜΗΝΑ] = month date field
[ΥΠΑΛΛΗΛΟΣID] =employeeid
[ΕΠΩΝΥΜΟ] = surname
[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ] = totals per week
can you help? i believe it is the syntax
i upload my db