Filter by GroupFooter Total in Access 2007

  • Thread starter Thread starter MIke_Mc
  • Start date Start date
M

MIke_Mc

Working in Access 2007. I wrote a query to pull by item nbr the item purchase
history for the year and compare the unit cost (link on Item Nbr) with the
list cost. To find any overpayments or short payments. The report is group by
item nbr, meaning that I have a subtotal by item in ItemNbr Footer
sum(overpayment) field, and a Grand total by vendor.

I want create a filter in my report to only see those items that their Total
overpayment (in the Item Footer) > Zero or to see only those items with
total overpayment <> Zero.
 
The typical solution is to create a totals query that calculates the values
you would want to filter on. Then add this totals query to your report's
record source and join the appropriate fields. You can then filter based on
your calculated totals.
 
Thanks Duane, I am able to filter now.
The only thing is that the report takes double the time to run, any
suggestion to reduce the time.
 
Back
Top