Newbies rberkness Posted April 26, 2006 Newbies Share Posted April 26, 2006 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! Link to comment Share on other sites More sharing options...
FMPing Posted April 26, 2006 Share Posted April 26, 2006 Calculate field Sum(Emp_No::hrs)/count(Emp_No::hrs) Link to comment Share on other sites More sharing options...
Newbies rberkness Posted April 27, 2006 Author Newbies Share Posted April 27, 2006 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 Link to comment Share on other sites More sharing options...
FMPing Posted April 27, 2006 Share Posted April 27, 2006 Solution in your email Link to comment Share on other sites More sharing options...
Lee Smith Posted April 27, 2006 Share Posted April 27, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6573 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now