need help with time/ hours worked calculation

[56th Rowallan]

Hi Guys

I need to create a method of calculating -week number,hours worked per week and a leiu hours total.

Explanation

Users enter their worked hours per day. I need to calculate the total hours worked per user per week and if this is greater or less than their contracted hours a record of this figure over a continual time period (or year).

Variables :- Time worked,Holiday hours,Leiu hours taken,Sick leave, Other authorised leave.

I realise that i'm asking on a lot but working for a charity has financial limits.

Attached the basic database-so far

Thanks in advance for your help

Row

 

[Kraj]

I think what you want to accomplish can be done using groups on your report. In your report design, go to View -> Sorting and Grouping. There you can tell the report to group on each value of employee and each instance of a timecard variable. Set the group to have a group footer. In the group footers add a text box that sums the values in each group (ie., total vacation hours for Bob Jones). Then, in the group footer for each employee you can add a text box that performs whatever calculation you need for your comparrison.

 

[56th Rowallan]

Many thanks for your help. Is there some way this can be done on Forms?

 

[Kraj]

It's probably doable but it would be more complicated. The same principle would still apply: you'd need to add text boxes in which to do your various calculations.

 

[56th Rowallan]

Thanks I'll take your advice, as a report would do the job well enough. Again many thanks

Row