Relational Database-Totals

[lgonzales]

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.

[BobWeaver]

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.