Filter by GroupFooter Total in Access 2007

[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.

 

[Duane Hookom]

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.

 

[MIke_Mc]

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.

 

[Duane Hookom]

I would make sure the appropriate fields are indexed. Check Allen Browne's
page on 2007 at http://allenbrowne.com/Access2007.html and Tony Toews
performance page at http://www.granite.ab.ca/access/performancefaq.htm