I made a quick database to calculate the total hours worked using (last time - first time), and deducting a lunch if applicable. I have made a report that summerizes the hours by employee for that database (which containes only 1 week of data). I get the total hours worked for each employee once I've sorted by the employee number using a summary. But now I need the average hours worked per week, so I need an average of the sum of a group of records. How?

Any help would be appriciated.

Thanks!

Calculate field

Sum(Emp_No::hrs)/count(Emp_No::hrs)

That didn't work either. I have attached a copy of the database. It's one of my first few, and I know it's messy but maybe someone can help with the problem. The report that I'm trying to get to work is the layout called "Report." Email me at [email protected] if you have any questions, or ideas.

Thanks!

1-24-05_to_1-30-05.zip

Solution in your email

Please attach solutions files here instead of sending them directly to the Members, that way others with the same problem can also benefit.

TIA

Lee