total hours each day

[mallikai]

i've got a timesheet dbase where employees enter their time for each client each day. Thus, there can be 10-12 entries per day, per employee. Is there a way to calculate HOURS PER DAY PER EMPLOYEE.

The only way I have thought is to do an if or case function

Case (date (day, month, year), sum(hrs), 0)

and then do a summary on that case

but that would mean doing that 365 times X 2?

anyone have suggestions?

thanks!

Gary

[Garry Claridge]

From your "employees" database create a relationship with the "timesheet" database. Then use a portal to Sum() the hours for each employee.

You could also use a 'self-join' for the same purpose.

All the best.

Garry

[ February 09, 2002, 06:28 PM: Message edited by: Garry Claridge ]