new database that calculates workhours per empolyee? help?

Manos39

Registered User.
Local time
Today, 01:14
Joined
Feb 14, 2011
Messages
248
How could i insert the already result of workhours ( they are calculated in excel) as a number of every employee so they are calculated to the day i shall start using that database that calculates workhours per employee? Need to make a table? and how would the table connect to the table of employees and table workdays?
 
You don't need to store the calculated hours from excel into your database. Just store the raw data and let Access calculate the numbers for you.

Please post a sample database to get a detailed answer.

Try searching the site for related posts. I've seems this problem addressed a few times.

HTH:D
 
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..
 

Attachments

Remind me i have to send in a motion to make the LOCATION field of forum user mandatory;)

Everything can be done in Access. Most of the time i seek pleasure in finding an answer in queries. I am convinced your answer can be found in a query or queries.

In this case i'd use a query to solve part of the problem (running sum). In another query i'd combine this query with Qry1.

Can you simplify your problem in a sample database (or in text) using english or dutch language? Otherwise it takes too long to come up with a suitable answer.

HTH:D
 

Users who are viewing this thread

Back
Top Bottom