I need an asistance in my database please. In query "Qr1" there in the last field i calculate workhours during weeks per employee.


[u]I need a running sum of workhours per employee in a new field. I think there should be an expression with the funxion Dsum. Can you help?
notice that field [ΑΝΑ ΕΒΔ]: Format([ΗΜΕΡΑΥΠΗΡΕΣΙΑΣ];"yyyy-mm-ww")] brings the weed number and ΗΜΕΡΑΥΠΗΡΕΣΙΑΣ is a day/time field.
i need running sum of field [ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]: [ΗΜΕΡΕΣ ΕΡΓΑΣΙΑΣ]*8,5+([ΚΩΛΗΘΗΚΕ]*4,857142857)-[ΘΕΩΡ ΩΡΕΣ ΥΠΑΛΛΗΛΟΥ]+([ΣΕ ΕΙΔ ΑΔΕΙΑ]*6,8) in a new field [TOTALS]
where every employee from field [ΕΠΩΝΥΜΟ] in the have totals of hours for weeks they worked.

[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ] is the calculated hours per week.
Please help!!