Report To Query

[TechNat]

I already have the report with all the information that I need. The problem that I am having, is that I need to filter each record by a expression that I have in the report.

The expression that I have sums up the total hours for the week for each employee. This is in the report.

Now when I try to do this in the query, it sums all the hours up for all employees. I only need per employee.

Is there any way to take the expression from the report with the information I need and put it into a query that can be filtered and put back into the report?

 

[Pat Hartman]

Anything you need to filter or sort by must be in the query rather than in the report. Assume you want to filter by a sum for example, the report should only include people who worked more than 50 hours in a week. You need to make a totals query that sums the hours worked by person by week. You would then join that query to your main query and you can add criteria that will limit the employees selected to those that worked more than 50 hours.

 

[TechNat]

Thanks

Thanks for the help!