calculate hours based on day of week

[mallikai]

i have a timesheet database where employees input their hours based on a date and client..

(an employee can have 6 to 7 entries for one day)

most employees are paid hourly and I don't know how to figure out a way to add hours for each day so that I can create a layout that has

employee day 1 (hrs) day 2 (hrs) day 3 (hrs) etc

thanks

gary

[Fitch]

Is each time entry a new record? Then you need to use Summaries.

Summary fields perform the calculations, like so: Total(EmployeeHours)

Sub-Summary parts display the summary fields on your layouts, but they depend on the records being sorted in the order that you define for the sub-summary part, in this case by date/employee. (Leading and trailing grand summaries don't depend on sort order.)

So your report layout will have first a sub-summary part sorted by date. Put the date field on this part. Next make a sub-summary part sorted by employee and put the employee name field on this part, and next to it the Total(EmployeeHours) field.

Sort by Date, Employee and then Preview or Print. (Sub-Summaries don't appear in Browse mode.)