Totaling Groups

  • Thread starter Thread starter Jon K
  • Start date Start date
J

Jon K

I am attempting to get totals for groups and yet still
list all the records within that group. Then I need to
filter out these groups, totals that do not reach a
certain amount. For instance, I am totaling items bases on
employee's names and need to total for each employee. Then
I only want to have those employees that have a total
above a certain level. I can group and total on a report,
but can not eliminate the employees who's totals are to
low.
 
Hi Jon,

You need two queries to accomplish this. First, create an aggregate query
that groups the employee name (or ID) and sum the field you want to total.
Next, create a second query linking the main table with the aggregate query
you just created by employee and set the criteria based on the summed field
from the aggregate query. This should give you the results you seek.

Hope this helps,
- Glen
 
Back
Top