A database to calculate workhours has to invovle last months workhours how? help..

[Manos39]

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 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)

 

[Guus2005]

Apparently one can choose to work between 05:30-14:00, 13:30-22:00, 21:30-06:00 and 08:00-16:00. Three shifts of 8.5 hours and one overlapping shift of 8 hours which seem to be normal working hours.
You might want to add an additional column in the orariatbl whuich shows the number of hours per shift since ΩΡΑΡΙΟ is a textfield. having done that calculating the working hours will be easier.

Having said that, i don't understand your language so i don't know where to start.
Could you put a sample together in any other language but greek, hebrew or latin?

HTH