Newbies lgonzales Posted March 21, 2001 Newbies Share Posted March 21, 2001 I have 3 relational databases 1.for employee data, 2. for courses taken by each employee, and 3. for course identification (course name and hours). I am able to calculate the total hours for each employee in 2. courses taken by employees database by creating a summary report. My problem is that sometimes I need to conduct a query on staff that has taken more than or less than a specific number of hours. I have been running a complete report for all personnel in a specific department with all the totals for each one. Then I manually find the people with totals over 25 hrs. This is a very time consuming process. There must be some other way to do this. Thank you in advance for your suggestions. Link to comment Share on other sites More sharing options...
BobWeaver Posted March 22, 2001 Share Posted March 22, 2001 You can set up a new calculated field with the GetSummary() function using the same criteria that you use for your summary field/report. Then search this field values >25. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8458 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