Time Card Report Problems

[lazyyy]

I just recreate my time card from a FMP template with all the repeating field, into a separate record, since I'll be using an automatic data entry.

Now lies my problem, its simple.

I'm generating a monthly report for each employee, and each total hours they've been working.

so I relate the employee table and time card table to create the report.

How do I summarize total working hours for each employee, monthly in the report?

I tried a summarize field in timecard table with no success.

should I create a summarize field in the employee table?

but how about the monthly part?

Help

Thanks for all the inputs

Edited November 3, 2006 by Guest