I made a db to calculate workhours of employees, their model of work
and calculations constist of work per week and then per month. So each
has at the end of the month some workhours worked. I need to bring
last month workhours for every employee when i start using the
database.. Here is my db if you can come with an idea..
the table ypaliloitbl is for employees
The table named "proigoumenesorestbl" in which the field
ΠΡΟΗΓΟΥΜΕΝΟΣΥΝΟΛΟΩΡΩΝ will contain the total of workhours employees
have worked till time the database will start to be used.
the query used to calculate workhours over weeks (Qrevdomada)
the query used to calculate running sum, over months (Qrminas)
|
Similar Threads
