Here is my db, what i would like is to ask..
In query "Qr1" there in the last field i calculate workhours during weeks per employee.
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.
Again if it could not be done, i would like a way to store the weeks calculated data [ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ] somehow i dont know and being somewhere where i could make use of them, table mostly? And of course for instance what this db will do is to replase an excel made file where the data [ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ] are being till now calculated.. How do i import them and where and how to use the data for each employee because they are relevant to the calculation of workhours. for example someone till now has 180 hours worked. The weeks calculation of workhours need the 180 value for calculating the differense of previus hours.. Thank you already for the bother..